Please note that the 'address 2' and 'address 3' spaces are for those service providers who serve clients from two or three offices. If you do not do so, please leave the extra address spaces blank.
"; $markyvar=0; if($prov2letter=="BC"){$servProTable="service_providers";$hinttab="hints";} else if($prov2letter=="AB"){$servProTable="service_providers_ab";$hinttab="hints_ab";} else if($prov2letter=="SK"){$servProTable="service_providers_sk";$hinttab="hints_sk";} else if($prov2letter=="MB"){$servProTable="service_providers_mb";$hinttab="hints_mb";} else if($prov2letter=="ON"){$servProTable="service_providers_on";$hinttab="hints_on";} else if($prov2letter=="QC"){$servProTable="service_providers_qc";$hinttab="hints_qc";} else if($prov2letter=="NS"){$servProTable="service_providers_ns";$hinttab="hints_ns";} else if($prov2letter=="NB"){$servProTable="service_providers_nb";$hinttab="hints_nb";} else if($prov2letter=="PE"){$servProTable="service_providers_pe";$hinttab="hints_pe";} else if($prov2letter=="NL"){$servProTable="service_providers_nl";$hinttab="hints_nl";} else if($prov2letter=="YK"){$servProTable="service_providers_yk";$hinttab="hints_yk";} else if($prov2letter=="NW"){$servProTable="service_providers_nw";$hinttab="hints_nw";} else if($prov2letter=="NV"){$servProTable="service_providers_nv";$hinttab="hints_nv";} else {$markyvar=1;} if($markyvar==0) { $query="INSERT INTO $servProTable (Pro_id, userPropassword,Proftitle, Profname, Prolname, Proconame, Proemail, Prophone, Profax, Proaddress1, Proaddress2, Procity, Proprov, Propostal, ProconameA, Proaddress1A, Proaddress2A, ProcityA, ProprovA, PropostalA, ProconameB, Proaddress1B, Proaddress2B, ProcityB, ProprovB, PropostalB, Website, Pro_type, lastaccess, rat_unsp, rat_insur, rat_law, rat_govt, rat_mil, rat_rehab, registered, reg_until, discount_code, nbk, ncl, listing_only) VALUES('$tempPro_id', password('$tempuserPropassword'), '$tempProftitle', '$tempProfname', '$tempProlname', '$tempProconame', '$tempProemail', '$tempProphone', '$tempProfax', '$tempProaddress1', '$tempProaddress2', '$tempProcity', '$tempProprov', '$tempPropostal', '$tempProconameA', '$tempProaddress1A', '$tempProaddress2A', '$tempProcityA', '$tempProprovA', '$tempPropostalA', '$tempProconameB', '$tempProaddress1B', '$tempProaddress2B', '$tempProcityB', '$tempProprovB', '$tempPropostalB', '$tempWebsite','$tempPro_type', NULL,0,0,0,0,0,0,'$todaysdate','$todaysdate','$discount_code', '$nbk', '$ncl',0)"; // $result=mysql_query($query); if(!$result) error_message($query); $query2="INSERT INTO $hinttab (hint_id, user_id, user_type, hint) VALUES (NULL, '$tempPro_id',1,'$password_hint')"; $result2=mysql_query($query2); if(!$result2) error_message(sql_error()); }///end if markyvar } if($result) { $_SESSION['userProid'] = $_POST['Pro_id']; $_SESSION['userProprov']=$tempProprov; /////EMAIL NEW USER INFO////// $newuser_mail_body = "A new service provider named "; $newuser_mail_body .= $_POST['Pro_id']; $newuser_mail_body .= " has registered as a service provider."; $newuser_mail_address = "admin@zappointments.com"; $newuser_mail_subject = "New Service Provider Registered"; $newuser_mail_added = "From: admin@zappointments.com\r\n"; $newuser_mail_added .= "Reply-to: admin@zappointments.com"; mail($newuser_mail_address, $newuser_mail_subject, $newuser_mail_body, $newuser_mail_added); ?>
";} ?>