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:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 2:17 PM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] MySQL Date insert
> 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',
> '$name', '$store', '$date'")
> or die("Invalid query: " . mysql_error() .
> 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.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php