|
|
Posted by John Nichel on 09/26/05 21:19
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@kegworks.com
Navigation:
[Reply to this message]
|