insert date string to mysql datetime field

[Anon]

Hello developers:

I have 3 pulldowns, one for day, month and year, and i want to insert them into a mysql datetime field:

of course the values i have after the user selects date is, p. ex.

$Year="2000";
$Month="11";
$Day="23";
...
$Mydate = $Year.$Month.$Day;

so my sql string if formed like:

mysql_quey(...,"insert into mytable values (NULL, '$Mydate'");

but i have recieved and error that it can not insert my value date !!!

can you help me please ??? 10s !!!

[Anon]

Hi Mariano,

i think the mysql_quey is just in the post wrong :-)) I can't promise, but i save my date fields in the form $Mydate = $Year."-".$Month."-".$Day ... and never had any problems ...

Another good hint for solving mysql problems is: Use PHPMyAdmin and submit your mysql query in this totaly cool tool !! You always get an better error-message then from your script !!

cya Rob

[Anon]

Should yout insert statement incude the field name?

INSERT into mytable (yourfieldname) VALUES ('$Mydate')

-Paul

[Anon]

Here's an example that may help

$d = date("Y-m-d");
sql="INSERT INTO table_name (date_row) VALUES (\"$d\")";
mysql_query($sql);