note 10752 rejected and deleted from mysql_query by zak

From: Date: Sat, 20 Jan 2001 12:59:33 +0000
Subject: note 10752 rejected and deleted from mysql_query by zak
Groups: php.notes 
Request: Send a blank email to php-notes+get-10003@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 ..

« previous php.notes (#10003) next »