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" <andrew@copeandmcphetres.com>
To: <php-db@lists.php.net>
Sent: Monday, July 28, 2003 2:16 PM
Subject: 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
