note 10752 added to mysql_query
| From: | endrocn at detik dot com | Date: | Sat, 20 Jan 2001 06:38:48 +0000 |
| Subject: | note 10752 added to mysql_query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-9995@lists.php.net to get a copy of this message | ||
Hi, I've tried to execut this query:
$ins=mysql_query("insert into table_name values($date1, $date2,
'$description')");
, and the result I've got in MySQL is that the date1 and date2 value return 0000-00-00. I tried
to print the value of the date1 and date2 prior to the MySQL query execution above and they are
printed in their correct values(e.g. 2000-01-01). And if I try to insert the same value from within
MySQL, it shows the correct result too.
Do you guys think I've missed something? Or perhaps I've used worng date format?
Thank's guys ..
http://www.php.net/manual/en/function.mysql-query.php