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]>
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() .
> 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
> formatting the date-time variable correctly but I've tried everything I
> think of, so any help is very much appreciated.  Thanks.
> Andrew.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to