HI There
This is the error I am receiving when trying to register on the site:
Column count doesn't match value count at row 1
error: failed to execute query INSERT INTO users (uname,uteln,umail,ustre,usubu,ucity,uprov,ucode,uuser,upass,uc_dt) VALUES
This is the regi.php coding. I cannot figure out the problem
<?php
if (isset($_POST['register'])) {
$query = "INSERT INTO users (uname,uteln,umail,ustre,usubu,ucity,uprov,ucode,uuser,upass,uc_dt) ".
"VALUES ('".$_POST['name']."','".$_POST['teln']."','".$_POST['mail']."','".$_POST['stre']."',".
"'".$_POST['subu']."','".$_POST['city']."','".$_POST['prov']."','".$_POST['code']."',".
"'".$_POST['user']."','".$_POST['pass']."','".date('Y-m-d H:i:s')."',uacti=2)";
$result = mysql_query($query)
or die(mysql_error()."<br><b>error</b>: failed to execute query <i>$query</i>");
mail('ndtsales@mweb.co.za','New User','New user requires activation.');
?>
<center>
Thank you for your registration.<br />
Your account requires activation.<br />
Once your account has been approved. You will be notified and will be able to continue shopping.
</center>
<?php
} else {
?>
<center>
<form method='post' action='?page=Registration'>
<h2 align='left'>Registration</h2>
<fieldset style='padding: 10px; text-align: left; width: 300px'>
<legend>Contact Details</legend>
<label>Full Name </label><br />
<input type='text' name='name' /><br />
<label>Contact Number </label><br />
<input type='text' name='teln' /><br />
<label>E-Mail Address</label><br />
<input type='text' name='mail' /><br />
</fieldset>
<fieldset style='padding: 10px; text-align: left; width: 300px'>
<legend>Delivery Details</legend>
<label>Street</label><br />
<input type='text' name='stre' /><br />
<label>Suburb</label><br />
<input type='text' name='subu' /><br />
<label>City</label><br />
<input type='text' name='city' /><br />
<label>Province</label><br />
<input type='text' name='prov' /><br />
<label>Code</label><br />
<input type='text' name='code' /><br />
</fieldset>
<fieldset style='padding: 10px; text-align: left; width: 300px'>
<legend>Login Details</legend>
<label>Login User Name</label><br />
<input type='text' name='user' /><br />
<label>Login Password</label><br />
<input type='password' name='pass' /><br />
</fieldset>
<p> </p>
<input type='submit' name='register' value='Register' /> <input type='reset' value='Clear' />
</form>
</center>
<?php
} // end if
?>