Re: mysql/php date functions..

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

 



bruce wrote:
thanks...

but that's not it john... i'm not worried about creating the sql_statement
in the php...

i'm concerned that i can't seem to craft/create a basic sql cmd within mysql
to get a value (other than NOW()) to work...

if i do (from mysql)
 -->> insert into foo (id, time) values (2, 333333), it doesn't work...
if i
 -->> insert into foo (id, time) values (2, NOW()), it works!!...

my question is why???

Without knowing the structure of your table, my guess is that the column time is expecting a valid timestamp, and 333333 is not a valid MySQL timestamp.

--
John C. Nichel
ÜberGeek
KegWorks.com
716.856.9675
john@xxxxxxxxxxxx

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux