"; 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"]; $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"]; $Prowebsite= $query_data["Website"]; $rat_unsp=$query_data["rat_unsp"]; $rat_insur=$query_data["rat_insur"]; $rat_law=$query_data["rat_law"]; $rat_govt=$query_data["rat_govt"]; $rat_mil=$query_data["rat_mil"]; $rat_rehab=$query_data["rat_rehab"]; $totalrating = $rat_unsp + $rat_insur + $rat_law + $rat_govt + $rat_mil + $rat_rehab; if($cityholder=="nonsuch") { echo "

Click on the city to get a list of psychologists in that area

"; $cityholder=$cityholder2; echo "

"; echo ""; echo $cityholder; echo ""; echo "

"; echo ""; echo "" . $Proftitle; if(empty($Proftitle)){echo "";} else {echo " ";} echo $Profname . " " . $Prolname . "'s sessions"; if($Prolname=='Provider') {echo "
this is a fictional provider for
demonstration purposes";} echo ""; echo "Info about"; echo " " . $Proftitle; if(empty($Proftitle)){echo $Profname , " ";} else {echo " ";} echo $Prolname . ""; echo " ("; echo $totalrating; echo " booked)"; echo ""; if($cityholder==$ProcityA) { echo "" . $Proaddress1A . "
" . $Proaddress2A . ""; } else if($cityholder==$ProcityB) { echo "" . $Proaddress1B . "
" . $Proaddress2B . ""; } else { echo "" . $Proaddress1 . "
" . $Proaddress2 . ""; } echo "
Send a confidential message
to " . $Proftitle; if(empty($Proftitle)){echo $Profname;} else {echo " ";} echo $Prolname . "
"; }///////end of if cityholder else if($cityholder != $Procity) { //$cityholder=$ProcityA; echo ""; echo "" . $Proftitle; if(empty($Proftitle)){echo "";} else {echo " ";} echo $Profname . " " . $Prolname . "'s sessions"; if($Prolname=='Provider') {echo "
this is a fictional provider for
demonstration purposes";} echo ""; echo "Info about"; echo " " . $Proftitle; if(empty($Proftitle)){echo $Profname . " ";} else {echo " ";} echo " " . $Prolname . ""; echo " ("; echo $totalrating; echo " booked)"; echo ""; if($cityholder==$ProcityA) { echo "" . $Proaddress1A . "
" . $Proaddress2A . ""; } else if($cityholder==$ProcityB) { echo "" . $Proaddress1B . "
" . $Proaddress2B . ""; } else {} echo "
Send a confidential message
to " . $Proftitle; if(empty($Proftitle)){echo $Profname . " ";} else {echo " ";} echo $Prolname . "
"; }/////end of else if cityholder not procity else { echo ""; echo "" . $Proftitle; if(empty($Proftitle)){echo "";} else {echo " ";} echo $Profname . " " . $Prolname . "'s sessions"; if($Prolname=='Provider') {echo "
this is a fictional provider for
demonstration purposes";} echo ""; echo "Info about"; echo " " . $Proftitle; if(empty($Proftitle)){echo $Profname . " ";} else {echo " ";} echo $Prolname . ""; echo " ("; echo $totalrating; echo " booked)"; echo ""; echo "" . $Proaddress1 . "
" . $Proaddress2 . ""; echo "
Send a confidential message
to " . $Proftitle; if(empty($Proftitle)){echo $Profname . " ";} else {echo " ";} echo $Prolname . "
"; }////end of else cityholder }////end of while }///end else //global $confmsg; $link_id = db_connect("appointments_db"); $query = "SELECT * FROM $servProdb WHERE Pro_type=1 ORDER by Procity"; $result = mysql_query($query); if(!mysql_num_rows($result)) {error_message("no data");return 0;} else { $cityholder="nonsuch"; echo ""; 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"]; $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 echo "
"; echo "

Click on the city to get a list of psychologists in that area

"; foreach($city_array as $each_city) { echo "

"; echo ""; echo $each_city; echo ""; echo ""; }//////////////end of foreach city_array }//////////// 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 "/library/webserver/phppsycorps/common_db.inc"; error_reporting(0); //session_register("user3id1"); global $servProdb; $cityholder=$_GET['cityholder']; $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";} echo ""; echo ""; echo ""; echo ""; echo "

Appointment booking method Patent Pending"; echo " LOGOUT

"; echo ""; echo ""; echo "
"; echo "

Back to psycorps.com home page

"; echo "

"; search_pro_db($cityholder, $provholder); echo ""; echo ""; ?>