Search Consultant

[php] global $wpdb;

//echo $var1.”
“;
//echo $var2.”
“;

if(!empty($_REQUEST[‘city’])) $where = ” and City like ‘%”.trim($_REQUEST[‘city’]).”%’ “;
if(!empty($_REQUEST[‘speciality’])) $where .= ” and speciality like ‘%”.trim($_REQUEST[‘speciality’]).”%’ “;
//echo $where.”
“;
//echo $where2.”
“;
$states = $wpdb->get_results( “SELECT * FROM consultant_speciality where approved = 1 $where” );
//echo “SELECT * FROM consultant_speciality “.$where.” and”.$where2;
$exist = count($states);
//echo $exist;
//echo “

";
//print_r($states);
//echo "

“;
[/php]

[php] if(!$exist){[/php]

[php]}else
foreach($states as $st) {[/php]

[php]}[/php]

No Match Found for your keyword
Name: [php]echo $st->Name;[/php] Speciality: [php]echo $st->speciality;[/php] Address: [php]echo $st->Address_hospital;[/php] City: [php]echo $st->City;[/php]