Links to $type_pro_plural: sessions, info, and messaging
";
echo "Clicking on the address will give you a map to the office.
";
$cityholder=$cityholder2;
echo "||||
";
echo "";
if($listing_only != 1)
{
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";}
} else {echo " | No online appointment
booking feature for ";echo $Profname . " " . $Prolname;}
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; echo " ";} else {echo " ";}
echo $Prolname . "
|
";
}///////end of if cityholder
else if($cityholder != $Procity)
{
//$cityholder==$ProcityA;
echo "";
if($listing_only != 1)
{
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";}
} else {echo " | No online appointments
booking feature for ";echo $Profname . " " . $Prolname;}
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 "";
if($listing_only != 1)
{
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";}
} else {echo " | No online appointment
booking feature for ";echo $Profname . " " . $Prolname;}
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();
$query = "SELECT * FROM $servProdb WHERE Pro_type=$gettype 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);
echo "
";
}//// 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 "";
echo $each_city;
echo " ";
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 $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";}
$gettype=$_GET['Protype'];
echo "";
echo "";
echo "";
echo "";
echo "";
echo "Appointment booking method Patent Pending";
echo " LOGOUT
";
echo "
";
echo "