auto insert date into my mysql db?

[craptakular]

I have a column called date of type 'date'

and have this :

mysql_query("INSERT INTO talename 
					(idproducts, product1, product2, product3, product4, product5, product6, date) VALUES('3', 'a', 'b', 'c', 'd', 'e', 'f', 'DATE: Auto CURDATE()')") 
or die(mysql_error());

but it no worky. What is wrong?

 

[Subliminal Aura]

oduct4, product5, product6, date

http://stackoverflow.com/questions/...ions-should-field-name-include-the-table-name

 

[craptakular]

how is this related to me? Please explain...

 

[Subliminal Aura]

how is this related to me? Please explain...

Quote

' I generally use 'id' as the primary key field name but in this case I think user_id and post_id are perfectly OK too. Note that the post date was called 'post_date" because 'date' is a keyword. '

 

[craptakular]

changed name to something generic and still didnt work

 

[Subliminal Aura]

What's the error message ?

 

[craptakular]

Column count doesn't match value count at row 1

When following this for date entry:

http://www.tizag.com/mysqlTutorial/mysql-date.php

The tutorial seems to show entering two values into my single 'todaysdate' column

 

[craptakular]

got it working, just used NOW() instead.