column count didn't match value count at row 1

[xanie]

i couldn't find any errors on it..

<?php
include ("../config/db.php");
$first  = $_POST['first_name'];
$last  = $_POST['last_name'];
$add  = $_POST['address'];
$age  = $_POST['age'];
$gender  = $_POST['gender'];
$contact = $_POST['contact_num'];
$email   =  $_POST['email_add'];
$pass   =  $_POST['password'];
$month  = $_POST['Month'];
$day  = $_POST['Day'];
$year  = $_POST['Year'];
$birthdate = "$month $day, $year";
$full  = "$first $last";
#############---------INSERT DATA-------############
mysql_query
("INSERT INTO register(

first_name,
last_name,
address,
age,
gender,
birthday,
contact_num,
email_add,
password


)
VALUES(
'$first',
'$last',
'$add',
'$age',
'$gender',
'$birthdate'
'$contact'
'$email',
'$pass'


)")or die(mysql_error());
##########------------SEND MAIL----------------############

$message= "$first <br />
  $last <br />
  $pass

  <p>Your email address will serve as your username.</p>
  <p>Thank You!</p>";

echo"$message";

$send_to= $email;
$subject= "Register";
$headers .= 'From: '.$email.'' . "\r\n";
$headers .= "Reply-To: [email]mail@genasiabiotech.com[/email]\r\n";
$headers .= "MIME-Version: 1.0\r\n";
$headers .= "Content-Type: text/html; charset=ISO-8859-1\r\n";
$headers .= "Content-Transfer-Encoding: 8bit;\r\n\r\n";
$headers .= stripslashes($input);
$headers .= "\r\n";

mail($email,$subject,$message,$headers);
?>

[Barand]

$birthdate = "$month $day, $year";

You are getting the error because your date contains a comma you have commas missing after date and contact values

 

If you are storing dates in a DB table use the DATE or DATETIME types and the format is YYYY-MM-DD. Your current format is useless in a database other than for printing. You cannot do any sorting or date comparisons or easily use any of the dozens of date functions the mysql provides.

Edited January 15, 2013 by Barand