Andrew, try this:

    $date = date('Y m d H i s');

A similar syntax (with single quotes rather than double, and without
intervening dashes) has worked for me in some MySQL-related PHP code I've
just written.   My code looked like this:

    $title2 = "\n<h3 align=\"center\">".date('l F d Y')."\n</h3>";

Michele Petrovsky

----- Original Message ----- 
From: "Andrew D. Luebke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, July 28, 2003 2:16 PM
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