$county = substr($_SERVER['QUERY_STRING'], 3, 197);
$county= str_replace("%20", " ", $county);
echo "SVPA Member Psychologists
\n";
?>
return to SVPA
//$state = substr($_SERVER['QUERY_STRING'], 3, 2); $query = "Select * from business, member WHERE business.business_id = member.member_id AND business.county REGEXP '^$county' ORDER BY business.state, member.lname"; $result = mysqli_query($conn,$query); while ($myrow = mysqli_fetch_assoc($result)) { if ($myrow["is_publish"] == "Yes") { echo "
| ".$myrow["fname"]." ".$myrow["lname"].", ".$myrow["degree"]." \n".$myrow["practice_summary"]." | ";
echo "License: ".$myrow["license_number"]." \n".$myrow["city"]." ".$myrow["state"]." | ";
echo "
\n"; echo "\n"; } } ?>