Re: MySQL Date insert

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



From: "Andrew D. Luebke" <andrew@copeandmcphetres.com>
>          $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.

Like someone else said, using Date as a column name probably isn't very
smart. Your problem is caused by not having a closing parenthesis in your
query, though.

'$date')")

---John Holmes...


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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux