Associate Member Search

Locate an Associate Member in your area by alpha.

  A  |  B  |  C  |  D  |  E  |  F  |  G  |  H  |  I  |  J  |  K  |  L  |  M  |  N  |  O  |  P  |  Q  |  R  |  S  |  T  |  U  |  V  |  W  |  X  |  Y  |  Z   

$value){
if (is_array($value)) {
$_values[$key] = join(“%,% “,$value);
$searchQuery = $_values[$key];
break;
} else $_values[$key] = $value;
$_values[$key]=stripslashes($_values[$key]);
//echo “
DBG VALUE:”. ($_values[$key]) .” “;
$searchQuery = $_values[$key];
break;
}
?>

<?PHP
function db_searchname($searchQuery) {
if($searchQuery != '') {
$query = "SELECT * FROM hfam_live.businesses WHERE company LIKE '".$searchQuery."%' ORDER BY company ASC";
} else {
$query = "SELECT * FROM hfam_live.businesses WHERE company LIKE 'A%' ORDER BY company ASC";
}
$result = mysql_query($query) or die(mysql_error());
$num= mysql_numrows($result);
if ($num == 0) {
echo "No results were found. Please go back and try again.";
} else {
while($row = mysql_fetch_array($result)) {
echo "” . $row[‘company’] . “
“;
echo “”.$row[‘address1’].”
“;
if (($row[‘address2’]) != “”) {
echo “” . $row[‘address2’].”
“;
}
echo $row[‘city’] . “, ” . $row[‘state’] . ” ” . $row[‘zip’] . “
“;
// echo “County: ” . $row[‘county’] . “
“;
echo “Phone: ” . $row[‘phone’] . “
“;
echo “Services: ” . $row[‘services’] .”
“;
if (($row[‘url’]) != “”) {
echo “Website: “.$row[‘url’].”“;
}
echo “

“;
}
}
}
?>