"; //If they did not enter a search term we give them an error if ($find == "") { echo "

You forgot to enter a search term"; exit; } // We preform a bit of filtering $find = strtoupper($find); $find = strip_tags($find); $find = trim ($find); //Now we search for our search term, in the field the user specified $data = mysql_query("SELECT * FROM LANDSURVEYORS WHERE upper($field) LIKE'%$find%' AND display='1' AND type='$type' ORDER BY display_order ASC"); //And we display the results while($result = mysql_fetch_array( $data )){ $land_id = $result['land_id']; $type = $result['type']; $display = $result['display']; $keywords = $result['keywords']; $name = $result['name']; $company_name = $result['company_name']; $image_url = $result['image_url']; $land_id = $result['land_id']; $address_1 = $result['address_1']; $address_2 = $result['address_2']; $state = $result['state']; $point1 = $result['point1']; $point2 = $result['point2']; $point3 = $result['point3']; $point4 = $result['point4']; $point5 = $result['point5']; $point6 = $result['point6']; $email = $result['email']; $body_text = $result['body_text']; $tel = $result['tel']; $fax = $result['fax']; $web_link = $result['web_link']; $email = $result['email']; $map = $result['map']; $zip_code = $result['zip_code']; $date = $result['date']; $nice_title = strtolower(str_replace(" " , "-", $name)); if ($point1!="")$point1 ="

$point1

"; if ($point2!="")$point2 ="

$point2

"; if ($point3!="")$point3 ="

$point3

"; if ($point4!="")$point4 ="

$point4

"; if ($point5!="")$point5 ="

$point5

"; if ($point6!="")$point6 ="

$point6

"; if ($map!="")$map =""; if ($image_url!="")$image_url =""; if ($tel!="")$tel ="tel: $tel"; if ($fax!="")$fax =" fax: $fax"; if ($company_name!="")$company_name ="contact name: $company_name
"; if ($address_1!="")$address_1 =" address: $address_1, "; if ($address_2!="")$address_2 ="$address_2 "; if ($state!="")$state =", $state"; if ($email!="")$email1 ="email: $email"; if ($web_link!="")$web_link =" web: $web_link"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } //This counts the number or results - and if there wasn't any it gives them a little message explaining that $anymatches=mysql_num_rows($data); if ($anymatches == 0) { echo "

Sorry, but we can not find an entry to match your query

"; } } ?>