here."; //////////////functions/////////////////////////////////////////////////// function get_current_Pro() { global $Proftitle, $Propassword, $Profname, $Prolname, $Proconame, $Proemail, $Prophone, $Profax, $Proaddress1, $Proaddress2, $Procity, $Proprov, $Propostal, $ProconameA, $Proaddress1A, $Proaddress2A, $ProcityA, $ProprovA, $PropostalA, $ProconameB, $Proaddress1B, $Proaddress2B, $ProcityB, $ProprovB, $PropostalB, $Prowebsite, $Pro_type; global $PHP_SELF, $third_co1; if($_SESSION['userProprov']=="BC"){$servProdb="service_providers";} else if($_SESSION['userProprov']=="AB"){$servProdb="service_providers_ab";} else if($_SESSION['userProprov']=="SK"){$servProdb="service_providers_sk";} else if($_SESSION['userProprov']=="MB"){$servProdb="service_providers_mb";} else if($_SESSION['userProprov']=="ON"){$servProdb="service_providers_on";} else if($_SESSION['userProprov']=="QC"){$servProdb="service_providers_qc";} else if($_SESSION['userProprov']=="NS"){$servProdb="service_providers_ns";} else if($_SESSION['userProprov']=="NB"){$servProdb="service_providers_nb";} else if($_SESSION['userProprov']=="PE"){$servProdb="service_providers_pe";} else if($_SESSION['userProprov']=="NL"){$servProdb="service_providers_nl";} else if($_SESSION['userProprov']=="YK"){$servProdb="service_providers_yk";} else if($_SESSION['userProprov']=="NW"){$servProdb="service_providers_nw";} else if($_SESSION['userProprov']=="NV"){$servProdb="service_providers_nv";} $tempuserProid=$_SESSION['userProid']; $query_current="SELECT * from $servProdb WHERE Pro_id = '$tempuserProid'"; $result_current_query=mysql_query($query_current); $current_array=mysql_fetch_array($result_current_query); $Proftitle=$current_array["Proftitle"]; $Propassword=$current_array["userPropassword"]; $Profname=$current_array["Profname"]; $Prolname=$current_array["Prolname"]; $Proconame=$current_array["Proconame"]; $Proemail=$current_array["Proemail"]; $Prophone=$current_array["Prophone"]; $Profax=$current_array["Profax"]; $Proaddress1=$current_array["Proaddress1"]; $Proaddress2=$current_array["Proaddress2"]; $Procity=$current_array["Procity"]; $Proprov=$current_array["Proprov"]; $Propostal=$current_array["Propostal"]; $ProconameA=$current_array["ProconameA"]; $Proaddress1A=$current_array["Proaddress1A"]; $Proaddress2A=$current_array["Proaddress2A"]; $ProcityA=$current_array["ProcityA"]; $ProprovA=$current_array["ProprovA"]; $PropostalA=$current_array["PropostalA"]; $ProconameB=$current_array["ProconameB"]; $Proaddress1B=$current_array["Proaddress1B"]; $Proaddress2B=$current_array["Proaddress2B"]; $ProcityB=$current_array["ProcityB"]; $ProprovB=$current_array["ProprovB"]; $PropostalB=$current_array["PropostalB"]; $Prowebsite=$current_array["Website"]; $Pro_type=$current_array["Pro_type"]; } function update_Pro_form() { global $Proftitle, $Profname, $Prolname, $Proconame, $Proemail, $Prophone, $Profax, $Proaddress1, $Proaddress2, $Procity, $Proprov, $Propostal, $ProconameA, $Proaddress1A, $Proaddress2A, $ProcityA, $ProprovA, $PropostalA, $ProconameB, $Proaddress1B, $Proaddress2B, $ProcityB, $ProprovB, $PropostalB, $Prowebsite, $Pro_type; global $PHP_SELF, $third_co1; ?>

Update your service provider account!

Provider ID
Title
First Name
Last Name
email
phone number
fax number
Company name
Address 1
Address 2
City
Prov.
Postal Code
Other company name
2nd Address 1
2nd Address 2
2nd City
2nd Prov.
2nd Postal Code
Company name at address 3
Line 1 of Address 3
Line 2 Address 3
City at address3
Prov. of address 3
Postal Code at address 3
Website
Profession
0) {echo "INSERT the $countNew new Provinces
"; while(list(,$valProv)=each($newProvs)) { if($valProv=="BC"){$servProdb="service_providers";} else if($valProv=="AB"){$servProdb="service_providers_ab";} else if($valProv=="SK"){$servProdb="service_providers_sk";} else if($valProv=="MB"){$servProdb="service_providers_mb";} else if($valProv=="ON"){$servProdb="service_providers_on";} else if($valProv=="QC"){$servProdb="service_providers_qc";} else if($valProv=="NS"){$servProdb="service_providers_ns";} else if($valProv=="NB"){$servProdb="service_providers_nb";} else if($valProv=="PE"){$servProdb="service_providers_pe";} else if($valProv=="NL"){$servProdb="service_providers_nl";} else if($valProv=="YK"){$servProdb="service_providers_yk";} else if($valProv=="NW"){$servProdb="service_providers_nw";} else if($valProv=="NV"){$servProdb="service_providers_nv";} $query="INSERT INTO $servProdb SET Pro_id = '$tempuserProid', userPropassword='$Propassword', Proftitle='$tempProftitle_u', Profname='$tempProfname_u', Prolname='$tempProlname_u', Proconame='$tempProconame_u', Proemail='$tempProemail_u', Prophone='$tempProphone_u', Proaddress1='$tempProaddress1_u', Proaddress2='$tempProaddress2_u', Procity='$tempProcity_u', Proprov='$tempProprov_u', Propostal='$tempPropostal_u', ProconameA='$tempProconameA_u', Proaddress1A='$tempProaddress1A_u', Proaddress2A='$tempProaddress2A_u', ProcityA='$tempProcityA_u', ProprovA='$tempProprovA_u', PropostalA='$tempPropostalA_u', ProconameB='$tempProconameB_u', Proaddress1B='$tempProaddress1B_u', Proaddress2B='$tempProaddress2B_u', ProcityB='$tempProcityB_u', ProprovB='$tempProprovB_u', PropostalB='$tempPropostalB_u', Website='$tempProwebsite', Pro_type='$tempPro_type_u'"; $result=mysql_query($query); if(!$result) error_message(sql_error()); } } if($countOld > 0) {echo "DELETE the $countOld old Provinces
"; while(list(,$valProv)=each($oldProvs)) { if($valProv=="BC"){$servProdb="service_providers";} else if($valProv=="AB"){$servProdb="service_providers_ab";} else if($valProv=="SK"){$servProdb="service_providers_sk";} else if($valProv=="MB"){$servProdb="service_providers_mb";} else if($valProv=="ON"){$servProdb="service_providers_on";} else if($valProv=="QC"){$servProdb="service_providers_qc";} else if($valProv=="NS"){$servProdb="service_providers_ns";} else if($valProv=="NB"){$servProdb="service_providers_nb";} else if($valProv=="PE"){$servProdb="service_providers_pe";} else if($valProv=="NL"){$servProdb="service_providers_nl";} else if($valProv=="YK"){$servProdb="service_providers_yk";} else if($valProv=="NW"){$servProdb="service_providers_nw";} else if($valProv=="NV"){$servProdb="service_providers_nv";} $query="DELETE FROM $servProdb WHERE Pro_id = '$tempuserProid'"; $result=mysql_query($query); if(!$result) error_message(sql_error()); } } if($countOver > 0) {echo "UPDATE the $countOver overlapping Provinces
"; while(list(,$valProv)=each($overlapProvs)) { if($valProv=="BC"){$servProdb="service_providers";} else if($valProv=="AB"){$servProdb="service_providers_ab";} else if($valProv=="SK"){$servProdb="service_providers_sk";} else if($valProv=="MB"){$servProdb="service_providers_mb";} else if($valProv=="ON"){$servProdb="service_providers_on";} else if($valProv=="QC"){$servProdb="service_providers_qc";} else if($valProv=="NS"){$servProdb="service_providers_ns";} else if($valProv=="NB"){$servProdb="service_providers_nb";} else if($valProv=="PE"){$servProdb="service_providers_pe";} else if($valProv=="NL"){$servProdb="service_providers_nl";} else if($valProv=="YK"){$servProdb="service_providers_yk";} else if($valProv=="NW"){$servProdb="service_providers_nw";} else if($valProv=="NV"){$servProdb="service_providers_nv";} $query="UPDATE $servProdb SET userPropassword='$Propassword', Proftitle='$tempProftitle_u', Profname='$tempProfname_u', Prolname='$tempProlname_u', Proconame='$tempProconame_u', Proemail='$tempProemail_u', Prophone='$tempProphone_u', Proaddress1='$tempProaddress1_u', Proaddress2='$tempProaddress2_u', Procity='$tempProcity_u', Proprov='$tempProprov_u', Propostal='$tempPropostal_u', ProconameA='$tempProconameA_u', Proaddress1A='$tempProaddress1A_u', Proaddress2A='$tempProaddress2A_u', ProcityA='$tempProcityA_u', ProprovA='$tempProprovA_u', PropostalA='$tempPropostalA_u', ProconameB='$tempProconameB_u', Proaddress1B='$tempProaddress1B_u', Proaddress2B='$tempProaddress2B_u', ProcityB='$tempProcityB_u', ProprovB='$tempProprovB_u', PropostalB='$tempPropostalB_u', Website='$tempProwebsite', Pro_type='$tempPro_type_u' WHERE Pro_id = '$tempuserProid'"; $result=mysql_query($query); if(!$result) error_message(sql_error()); } $_SESSION['userProprov']=$tempProprov_u; } $query="UPDATE service_providers SET userPropassword='$Propassword', Proftitle='$tempProftitle_u', Profname='$tempProfname_u', Prolname='$tempProlname_u', Proconame='$tempProconame_u', Proemail='$tempProemail_u', Prophone='$tempProphone_u', Proaddress1='$tempProaddress1_u', Proaddress2='$tempProaddress2_u', Procity='$tempProcity_u', Proprov='$tempProprov_u', Propostal='$tempPropostal_u', ProconameA='$tempProconameA_u', Proaddress1A='$tempProaddress1A_u', Proaddress2A='$tempProaddress2A_u', ProcityA='$tempProcityA_u', ProprovA='$tempProprovA_u', PropostalA='$tempPropostalA_u', ProconameB='$tempProconameB_u', Proaddress1B='$tempProaddress1B_u', Proaddress2B='$tempProaddress2B_u', ProcityB='$tempProcityB_u', ProprovB='$tempProprovB_u', PropostalB='$tempPropostalB_u', Website='$tempProwebsite', Pro_type='$tempPro_type_u' WHERE Pro_id = '$tempuserProid'"; /*$result=mysql_query($query); if(!$result) error_message(sql_error());*/ if($result) { ?>

, thanks for updating your account information!

If you want to logout, click here."; echo "
If you want to check your appointments, click "; echo "here."; } } /////OMITTED THE DISPLAY INFO below//// ?>No service provider logged in. If you are a service provider, log in here ";} else if(empty($_SESSION['userProprov'])) {echo "
No service provider logged in. If you are a service provider, log in here ";} else {get_current_Pro(); update_Pro_form();} break; } ?>