"; echo "You searched for a BuildingSurveyor in: "; echo "" .$find; echo ""; echo "
"; //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' ORDER BY display_order ASC"); //And we display the results while($result = mysql_fetch_array( $data )){ $land_id = $result['land_id']; $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 ="Details & Map"; if ($image_url!="")$image_url ="$alt"; 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 "Details & Map"; echo "
    "; echo "
    "; echo "
    "; echo "
    "; echo "".$image_url.""; 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 "
      "; echo "".$point1.""; echo "".$point3.""; echo "".$point5.""; echo "
    "; echo "
    "; echo "".$map.""; echo "
    "; echo "
      "; echo "".$point2.""; echo "".$point4.""; echo "".$point6.""; 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

    "; } } ?>
    join buildingsurveyors.com
    surveyors.com
    iphone app