$authOff = 1;
require_once("includes/connect.inc");
$title="Welcome!";
//require_once("includes/header.inc");
if(isset($_POST['Submit'])){
if($f_name != "" && ($f_phone != "" || $f_email != "") && $f_pass1 == $f_pass2) {
$sqlUNCheck = "SELECT clientID FROM tblclient WHERE clientUserName = '$f_uname'";
$rsUNCheck = mysql_query($sqlUNCheck);
if(mysql_num_rows($rsUNCheck) <> 0){
$error = 2;
}
if($f_email == ""){
$error=3;
}
if($error < 2){
$sqlInsert = "INSERT INTO tblclient(clientUserName, clientPass, companyID, clientName, clientPhone, clientFax, clientEmail, clientAddr1, clientAddr2, clientCity, clientState, clientZip, clientNotes, auditstamp, audituser) VALUES('$f_uname', PASSWORD('$f_pass1'), $coid, '$f_name', '$f_phone', '$f_fax', '$f_email', '$f_addr1', '$f_addr2', '$f_city', '$f_state', '$f_zip', '$f_notes', NOW(), '0')";
//echo $sqlInsert;
mysql_query($sqlInsert) or die(mysql_error());
echo "Insert Successful";
redirect("index.php");
}}
else $error = 1;
if($error == 1)
echo "Please make sure that all fields have been entered correctly
";
if($error == 2)
echo "Your user name has already been chosen
";
if($error == 3)
echo "Please enter an email address, it makes it easier for me to get in touch with you about your orders.
";
}
?>