RE: [PHP-DB] MySQL Date insert

Nope, changed the insert to:

        $result = mysql_query("INSERT INTO Boats (Make, Model, Serial, Stock, Extension, Cust_Name, Store, Insert_Date) VALUES
                ('$make', '$model', '$serial', '$stock', '$extension', '$name', '$store', '$date'")
                or die("Invalid query: " . mysql_error() . "</body></html>");

with corresponding alter of the table of course, same error. Andrew. At 11:19 AM 7/28/2003, Hutchins, Richard wrote:

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. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php