Nothing found for $city_suburb in $state. Please click Back and try another search.
e.g. Check that Suburb matches State or by Postcode.
"); } else { echo("

"); echo("

"); if($distance <> "this_suburb") { if ($search_type == "locality") { if (msqlQuery($sock,"select distinct to_city_suburb from distance where from_city_suburb clike '$city_suburb' and distance_klms < $distance and from_state='$state' and to_city_suburb <> '$city_suburb'") <0) { fatal("Error : $ERRMSG\n"); } $res = msqlStoreResult(); $row = msqlFetchRow($res); if (msqlNumRows($res) < 1) { /* echo("

Error. $num_rows

");*/ } else { while (#$row > 0) { if ($type == "any_type") { $query2="select distinct record_no, business_name, city_suburb, cuisine from take_away_restaurants where city_suburb CLIKE '$row[0]' order by cuisine DESC"; } else { $query2="select distinct record_no, business_name, city_suburb, cuisine from take_away_restaurants where city_suburb CLIKE '$row[0]' and (cuisine ='$type' or cuisine='') order by cuisine DESC"; } if(msqlQuery($sock, $query2 ) < 0) { fatal("Error: $ERRMSG\n"); } $res2 = msqlStoreResult(); $row2 = msqlFetchRow($res2); if (msqlNumRows($res2) < 1) { /* echo("

Nothing found for $city_suburb in $state. Please click Back and try another search e.g. Postcode.
$query2

");*/ } else { echo(""); } msqlFreeResult($res2); $row = msqlFetchRow($res); $no_cuisine_counter = 0; } } msqlFreeResult($res); /****************************************************************************************************************************************************************/ } else { $postcode = $city_suburb; if (msqlQuery($sock,"select distinct to_city_suburb from distance where from_postcode='$city_suburb' and distance_klms < $distance and from_state='$state' and to_postcode <> '$city_suburb'") <0) { fatal("Error : $ERRMSG\n"); } $res = msqlStoreResult(); $row = msqlFetchRow($res); if (msqlNumRows($res) < 1) { /* echo("

Error.$num_rows

");*/ } else { while (#$row > 0) { if ($type == "any_type") { $query2="select distinct record_no, business_name, city_suburb, cuisine from take_away_restaurants where city_suburb CLIKE '$row[0]' order by cuisine DESC"; } else { $query2="select distinct record_no, business_name, city_suburb, cuisine from take_away_restaurants where city_suburb CLIKE '$row[0]' and cuisine='$type' order by cuisine DESC"; } if(msqlQuery($sock, $query2 ) < 0) { fatal("Error: $ERRMSG\n"); } $res2 = msqlStoreResult(); $row2 = msqlFetchRow($res2); if (msqlNumRows($res2) < 1) { /* echo("

Nothing found for $city_suburb in $state. Please click Back and try another search e.g. Postcode.
$query2

");*/ } else { echo(""); } msqlFreeResult($res); } } } msqlClose($sock); >