"#BBFFFF", "#FFBBFF", "#FFFFBB"); // $color_no = "0"; //echo "the color now is " . "$colorsettings[$color_no]
"; $link_id = db_connect(); if(!link_id) die(sql_error()); $query="SELECT CLfname, CLlname, CLemail, CLphone, CLaddress1, CLaddress2, CLcity, CLprov, CLpostal, CLthird_co1, third_party_email1, CLthird_co2, third_party_email2, CLthird_co3, third_party_email3, CLthird_co4, third_party_email4, CLthird_co5, third_party_email5 FROM $clients_db WHERE CL_id='$client_codename'"; $result=mysql_query($query); if(!$result) error_message(sql_error()); $num_rows=mysql_num_rows($result); if($num_rows) { //echo "";////line 42 while($query_data=mysql_fetch_array($result)) { $client_fname=$query_data["CLfname"]; $client_lname=$query_data["CLlname"]; $client_email=$query_data["CLemail"]; $client_phone=$query_data["CLphone"]; $client_address1=$query_data["CLaddress1"]; $client_address2=$query_data["CLaddress2"]; $client_city=$query_data["CLcity"]; $client_prov=$query_data["CLprov"]; $client_postal=$query_data["CLpostal"]; $client_third_co1=$query_data["CLthird_co1"]; $client_third_co2=$query_data["CLthird_co2"]; $client_third_co3=$query_data["CLthird_co3"]; $client_third_co4=$query_data["CLthird_co4"]; $client_third_co5=$query_data["CLthird_co5"]; $third_co_email1=$query_data["third_party_email1"]; $third_co_email2=$query_data["third_party_email2"]; $third_co_email3=$query_data["third_party_email3"]; $third_co_email4=$query_data["third_party_email4"]; $third_co_email5=$query_data["third_party_email5"]; ?>

Name	Address	book/cancel/block	client	bill to	location

Name
Address	"; if(!empty($client_address2)) { echo $client_address2; echo " "; } echo $client_city; echo ", "; echo $client_prov; ?>
Telephone
Client email
Insurer/3rd party 1
Insurer/3rd party 1's email
Insurer/3rd party 2
Insurer/3rd party 2's email
Insurer/3rd party 3
Insurer/3rd party 3's email
Insurer/3rd party 4
Insurer/3rd party 4's email
Insurer/3rd party 5
Insurer/3rd party 5's email

No such client in selected province. Try another province below:
"; echo "BC"; echo "  AB"; echo "  SK"; echo "  MB"; echo "  ON"; echo "  QC"; echo "  NB"; echo "  NS"; echo "  PE"; echo "  NL"; echo "  YK"; echo "  NWT"; echo "  NV"; } } ///////////BODY///////////////BODY///////////////////BODY//////////// session_start(); //session_register("user3id1"); //session_register("userCLid"); //session_register("userProid"); //session_register("pro_enter"); //$_SESSION['userProid']='zsaper'; //autoreload(); echo ""; echo""; echo ""; show_gif(); echo "

Appointment booking method Patent Pending"; if(isset($_SESSION['userProid'])) { echo "
Add appointments one at a time"; echo "
Set your weekly schedule

"; } if($_SESSION['userProid']==$_GET['Prolook']) { $CLlook_temp=$_GET['CLlook']; //echo "
Update this client's registration here. This will change the default client for booking (shown in control bar above) to be this client."; lookupCL_func($CLlook_temp); } else if($_GET['Prolook']==$_SESSION['user3id1']) { $CLlook_temp=$_GET['CLlook']; echo "
Update this client's registration here. This will change the default client for booking (shown in control bar above) to be this client."; lookupCL_func($CLlook_temp); } else { echo "

Cannot display information

"; } echo "";