";
while($query_data=mysql_fetch_array($result))
{
$Pro_id = $query_data["Pro_id"];
$Proftitle = $query_data["Proftitle"];
$Profname = $query_data["Profname"];
$Prolname = $query_data["Prolname"];
$Procity = $query_data["Procity"];
$ProcityA = $query_data["ProcityA"];
$ProcityB = $query_data["ProcityB"];
$Proprov = $query_data["Proprov"];
$ProprovA = $query_data["ProprovA"];
$ProprovB = $query_data["ProprovB"];
$Proaddress1 = $query_data["Proaddress1"];
$Proaddress2 = $query_data["Proaddress2"];
$Proaddress1A = $query_data["Proaddress1A"];
$Proaddress2A = $query_data["Proaddress2A"];
$Proaddress1B = $query_data["Proaddress1B"];
$Proaddress2B = $query_data["Proaddress2B"];
$Proemail=$query_data["Proemail"];
if (!$city_array) ///initialize array
{
$city_array = array();
if($Proprov==$provholder){$city_array[] = $Procity; }
if($ProprovA==$provholder){$city_array[] = $ProcityA; }
if($ProprovB==$provholder){$city_array[] = $ProcityB; }
}
else
{
if($Proprov==$provholder){$city_array[] = $Procity; }
if($ProprovA==$provholder){$city_array[] = $ProcityA; }
if($ProprovB==$provholder){$city_array[] = $ProcityB; }
}
}///end while
$city_array=array_unique($city_array);
}//// end else
$type_pro_plural=get_type_pro_from_num($gettype);
echo "";
echo "Click on the city to get a list of $type_pro_plural in that area
";
sort($city_array);
reset($city_array);
foreach($city_array as $each_city)
{
echo "";
echo "";
echo $each_city;
echo " ";
echo "
";
}//////////////end of foreach city_array
echo "
";
}//////////// E N D O F SEARCH_PRO_DB////////////
header("Expires: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
header("Cache-Control: post-check=0, pre-check=0");
include "../phppsycorps/common_db.inc";
error_reporting(0);
//session_register("user3id1");
//global $confmsg, $servProdb;
$provholder=$_GET['provholder'];
if($provholder=="BC"){$servProdb="service_providers";}
else if($provholder=="AB"){$servProdb="service_providers_ab";}
else if($provholder=="SK"){$servProdb="service_providers_sk";}
else if($provholder=="MB"){$servProdb="service_providers_mb";}
else if($provholder=="ON"){$servProdb="service_providers_on";}
else if($provholder=="QC"){$servProdb="service_providers_qc";}
else if($provholder=="NS"){$servProdb="service_providers_ns";}
else if($provholder=="NB"){$servProdb="service_providers_nb";}
else if($provholder=="PE"){$servProdb="service_providers_pe";}
else if($provholder=="NL"){$servProdb="service_providers_nl";}
else if($provholder=="YK"){$servProdb="service_providers_yk";}
else if($provholder=="NW"){$servProdb="service_providers_nw";}
else if($provholder=="NV"){$servProdb="service_providers_nv";}
$gettype=$_GET['Protype'];
echo "";
echo "";
echo "";
echo "";
echo "";
echo "Appointment booking method Patent Pending";
echo " LOGOUT
";
echo "
";
echo "