Re: mysql/php date functions..

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