I used the same code to register onother user officer works fine but the supplier does not work I does says they r registered but when I log in it says the user does not exist.I've looked since monday I give up anyidea what's wrong?????
php script
<?php
// Connects to your Database
mysql_connect("localhost", "root", "phpmysql") or die(mysql_error());
mysql_select_db("procdumy") or die(mysql_error());
//This code runs if the form has been submitted
if (isset($_POST['submit'])) {
//This makes sure they did not leave any fields blank
if ( !$_POST['username'] | !$_POST['password']|!$_POST['name'] |!$_POST['surname'] |!$_POST['company'] |!$_POST['tele'] |
!$_POST['fax'] |!$_POST['SuppName'] | !$_POST['bus_addr']|!$_POST['type'] |!$_POST['descr'] |!$_POST['cnt_person'] |
!$_POST['email'] | !$_POST['reg_no']| !$_POST['vat_no']) {
header("Location: regFail1.html");
//die('You did not complete all of the required fields<a href=addSupp.html>BACK</a>');
}
// checks if the username is in use
if (!get_magic_quotes_gpc()) {
$_POST['username'] = addslashes($_POST['username']);
}
$usercheck = $_POST['username'];
$check = mysql_query("SELECT username FROM users WHERE username = '$usercheck'")
or die(mysql_error());
$check2 = mysql_num_rows($check);
//if the name exists it gives an error
if ($check2 != 0) {
die('Sorry, the username '.$_POST['username'].' is already in use.<a href=addSupp.html>BACK</a>');
}
$_POST['password'] = md5($_POST['password']);
if (!get_magic_quotes_gpc()) {
$_POST['password'] = addslashes($_POST['password']);
$_POST['username'] = addslashes($_POST['username']);
}
$insert = "INSERT INTO users (username,password,status,name,surname,company,tel e,fax,SuppName,bussAddr,type,desciption,cnt_person ,email,regNum,vatNum)
VALUES ('".$_POST['username']."', '".$_POST['password']."', '".$_POST['status']."', '".$_POST['name']."', '".$_POST['surname']."',
'".$_POST['company']."', '".$_POST['tele']."', '".$_POST['fax'].",'".$_POST['SuppName']."', '".$_POST['bus_addr']."',
'".$_POST['type']."', '".$_POST['descr']."',
'".$_POST['cnt_person']."', '".$_POST['email']."', '".$_POST['reg_no']."', '".$_POST['vat_no']."')";
//$add_member = mysql_query($insert);
header("Location: regSuccess.html");
?>
<?php
}
?>
<?php
HTML Script::::
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Procurement Tracking System</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<form action="adSupplier.php" method="post">
<table width="100%" border="0">
<tr>
<td><img src="../Procurement/procurement.JPG"></td>
</tr>
</table>
<hr color="#000000">
<strong><font size="6">Register New Supplier</font></strong>
<p></p>
<div align="center">
<table width="544" border="1" bordercolor="#000000" bgcolor="#A6A653" class="text">
<table width="544" border="1" bordercolor="#000000" bgcolor="#A6A653" class="text">
<tr>
<td colspan="2"><strong>FILL IN ALL DETAILS</strong></td>
</tr>
<tr>
<td width="183" valign="top" ><font face="Verdana" size="2">Username:</font></td>
<td width="345"><input type="text" name="username" maxlength="60"></td>
</tr>
<tr>
<td height="20" valign="top"><font face="Verdana" size="2">Password:</font></td>
<td valign="top"><input type="password" name="password" maxlength="60"></strong></td>
</tr>
<tr>
<td height="20" valign="top"><strong><font face="Verdana" size="2">Status:
1=Supplier</font></strong></td>
<td valign="top"><strong><input type="text" name="status" maxlength="60"></strong></td>
</tr><strong>
<tr>
<td height="20" valign="top"><font face="Verdana" size="2">Name:</font></td>
<td valign="top"><input type="text" name="name" maxlength="60"></td>
</tr>
<tr>
<td height="20" valign="top"><font face="Verdana" size="2">Surname:</font></td>
<td valign="top"><input type="text" name="surname" maxlength="10"></td>
</tr>
<tr>
<td height="20" valign="top"><font face="Verdana" size="2">Company::</font></td>
<td valign="top"><input type="text" name="company" maxlength="10"></td>
</tr>
<tr>
<td height="20" valign="top"><font face="Verdana" size="2">Telephone Number::</font></td>
<td valign="top"><input type="text" name="tele" maxlength="10"></td>
</tr>
<tr>
<td height="20" valign="top"><font face="Verdana" size="2">Fax Number::</font></td>
<td valign="top"><input type="text" name="fax" maxlength="10"></td>
</tr>
</strong>
<tr>
<td height="20" valign="top"><strong><font face="Verdana" size="2">Supplier
Name :</font></strong></td>
<td valign="top"><strong><input type="text" name="SuppName" maxlength="60"></strong></td>
</tr><strong>
<tr>
<td height="20" valign="top"><font face="Verdana" size="2">Business Address:</font></td>
<td valign="top"><textarea type="text" name="bus_addr" rows="2" cols="16"></textarea></td>
</tr>
<td height="20" valign="top"><font face="Verdana" size="2">Business Type:</font></td>
<td valign="top"><input type="text" name="type" maxlength="60"></td>
</tr>
<tr>
<td height="20" valign="top"><font face="Verdana" size="2">Description:</font></td>
<td valign="top"><input type="text" name="descr" maxlength="60"></td>
</tr>
<tr>
<td height="20" valign="top"><font face="Verdana" size="2">Contact Person:</font></td>
<td valign="top"><input type="text" name="cnt_person" maxlength="60"></td>
</tr>
<tr>
<td height="20" valign="top"><font face="Verdana" size="2">E-mail:</font></td>
<td valign="top"><input type="text" name="email" maxlength="60"></td>
</tr>
<tr>
<td height="20" valign="top"><font face="Verdana" size="2">Registration Number:</font></td>
<td valign="top"><input type="text" name="reg_no" maxlength="60"></td>
</tr>
<tr>
<td height="20" valign="top"><font face="Verdana" size="2">Vat Number:</font></td>
<td valign="top"><input type="text" name="vat_no" maxlength="60"></td>
</tr>
</strong>
</table>
<p></p>
<div align="center">
<input type="submit" name="submit" value="Add">
<input type="Reset" value="Reset" ></div>
<hr color="#000000">
</form>
</body>
</html>
Thanx In advance