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
> 
> 
> 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. 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to