insert dates

[fnbcprog]

Here's what i am trying to do...

I have an application that inserts classifieds into a table with a timestamp for creation and timestamp for expiration.

I am trying to do an automated insert so that i dont have to use the PHP code something to this effect:

insert into auto (ts_placed,ts_expire) VALUES (now(),date_add(now(),INTERVAL 1 MONTH));

however that is not working. Both of my column types are datetime??

Do you have any suggestions??

[LordShryku]

Care to expand on "not working"? Any errors output?

[fnbcprog]

Got it working last night....Thanks for the reply though!