RE: [PHP-DB] MySQL Date insert

Don't know about your date format, but you have named your table column DATE which is a reserved keyword in MySQL. Try naming that something different and see if you still get the error. > -----Original Message----- > From: Andrew D. Luebke [mailto:andrew@copeandmcphetres.com] > Sent: Monday, July 28, 2003 2:17 PM > To: php-db@lists.php.net > Subject: [PHP-DB] MySQL Date insert > > > Hello, > I have the following PHP code: > > $date = date("Y-m-d H:i:s"); > $result = mysql_query("INSERT INTO Boats (Make, > Model, Serial, > Stock, Extension, Cust_Name, Store, Date) VALUES > ('$make', '$model', '$serial', > '$stock', > '$extension', > '$name', '$store', '$date'") > or die("Invalid query: " . mysql_error() . > "</body></html>"); > > The problem is with the Date column. It is of type DATETIME. > I get an > error on the second line of the insert statement. I assume > I'm not putting > formatting the date-time variable correctly but I've tried > everything I can > think of, so any help is very much appreciated. Thanks. > > Andrew. >