Inserting date into mysql table

[zulubanshee]

I have a string '2009-01-20' I want to insert into a mysql table, but all dates are being inserted as 1969-12-31. I assume there is some conversion necessary. I tried:

$date = date('Y-m-d', $date);

but it does the same thing. The date will not necessarily be today.

[zulubanshee]

using php if that was not obvious. :)

[sonjay]

What's your query look like?

[zulubanshee]

$day = $_POST['day'];
$month = $_POST['month'];
$year = $_POST['year'];
$date = $year."-".$month."-".$day;

$sql = "insert into com_sales (sale_id, sales_rep, customer_name, customer_phone, dialer_or_email, payment_type)
values
(sale_id,'$sales_rep','$customer_name', '$customer_phone', '$dialer_or_email', '$payment_type', '$date')";

[sonjay]

If you put this on the page:
echo $sql;
what do you get?

And if you run the sql, like this, what do you get:
$insert = mysql_query($sql) or die(mysql_error());

Is a MySQL error generated? If so, what does it say?

[LifeinAsia]

You're specifying 6 fields to insert, but 7 values. Most DBs would throw an error. If yours isn't, it's most likely just ignoring the 7th value.