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 ="

"; 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 $result['name']; echo "
"; echo ""; echo "".$company_name.""; echo "".$tel.""; echo "".$fax.""; echo "".$address_1.""; echo "".$address_2.""; echo "".$zip_code.""; echo "".$state.""; echo "
"; echo ""; echo "".$email1.""; echo "".$web_link.""; echo "
"; echo ""; echo "- ";
echo "".$point1."";
echo "".$point3."";
echo "".$point5."";
echo "
- ";
echo "".$point2."";
echo "".$point4."";
echo "".$point6."";
echo "