// WHERE clause filters
$arrSQLFilters = array();
// whether or not zip codes table needs to be included
$boolIncludeZipCodes = false;
// Zipcode filter
if(!empty($strZipCode)) {
$boolIncludeZipCodes = true;
$arrSQLFilters[] = sprintf(
"z.zip LIKE '%s'"
,"%$strZipCode%"
);
}
// State filter
if(!empty($strState)) {
$boolIncludeZipCodes = true;
$arrSQLFilters[] = sprintf(
"z.state = '%s'"
,$strState
);
}
// Restaurants name filter
if(!empty($strName)) {
$arrSQLFilters[] = sprintf(
"r.restaurantname LIKE '%s'"
,"%$strName%"
);
}?>