if ( $results <> null ) { ?>
Search Results:
if (( $subcategoryid > 0 ) and ( $rowcount > 0 )) { echo ""; echoHTML( categoryName( $con, $categoryid )); echo ": "; echoHTML( subCategoryName( $con, $subcategoryid )); } else if (( $categoryid > 0 ) and ( $rowcount > 0 )) { echo ""; echoHTML( categoryName( $con, $categoryid )); } if ( $searchtext ) { echo "Search Text: "; echoHTML( $searchtext ); } ?>
Call for more specific information on fees, hours of operation, etc.
for( $index = 0; $index < $rowcount; $index++ ) { $Row = pg_fetch_object( $results, $index ); ?>"; } ?> if ( trim( $Row->address ) <> "" ) { echo htmlClean( $Row->address ); echo "
"; } ?> if (( trim( $Row-> city ) <> "" ) or ( trim( $Row->state ) <> "" ) or ( trim( $Row->postalcode ) <> "" )) { echo htmlClean( $Row->city ); echo " "; echo htmlClean( $Row->state ); echo " "; echo htmlClean( $Row->postalcode ); echo "
"; } ?> if (( trim( $Row->phone1 ) <> "" ) and ( trim( $Row->type1 ) <> "" )) { echo htmlClean( $Row->type1 ); echo ": "; echo htmlClean( $Row->phone1 ); echo "
"; } ?> if (( trim( $Row->phone2 ) <> "" ) and ( trim( $Row->type2 ) <> "" )) { echo htmlClean( $Row->type2 ); echo ": "; echo htmlClean( $Row->phone2 ); echo "
"; } ?> if (( trim( $Row->phone3 ) <> "" ) and ( trim( $Row->type3 ) <> "" )) { echo htmlClean( $Row->type3 ); echo ": "; echo htmlClean( $Row->phone3 ); echo "
"; } ?> if (( trim( $Row->phone4 ) <> "" ) and ( trim( $Row->type4 ) <> "" )) { echo htmlClean( $Row->type4 ); echo ": "; echo htmlClean( $Row->phone4 ); echo "
"; } ?> if ( trim( $Row->url ) <> "" ) { echo "URL: url ); echo "\">"; echo htmlClean( $Row->url ); echo "
"; } ?> if ( $Row->programsforolderadults == 't' ) echo "Offers specialized programs for adults: Yes
"; ?> $q2 = "select c.category, s.subcategory, rc.notes from category c, resourcesubcategory rc, subcategory s where rc.resourceid = " . dbClean($Row->resourceid) . " and rc.subcategoryid = s.subcategoryid and s.categoryid = c.categoryid"; if ( $subcategoryid > 0 ) $q2 .= " and s.subcategoryid = " . dbClean($subcategoryid); else if ( $categoryid > 0 ) $q2 .= " and c.categoryid = " . dbClean($categoryid); $q2 .= " order by upper(c.category), upper(s.subcategory)"; if ( $results2 = pg_exec( $con, $q2 )) for( $index2 = 0; $index2 < pg_numrows( $results2 ); $index2++ ) if ( $row2 = pg_fetch_object( $results2, $index2 )) { ?> echo htmlClean( $row2->category ) ?>: echo htmlClean( $row2->subcategory ) ?>
} ?> } else { ?>
Search the Guide
if ( $noresults ) { ?>No results were found. Please try a less restrictive search.
} ?> if ( $categoryid > 0 ) { ?>To see all resources in this category, click the "Search the Guide" button below.
Or, to further define your search, select a sub-category and then click the "Search the Guide" button.
} else { ?>You can search the online resources by category, by text or both.
} ?> } ?>