MySql time problem

[cash_hr]

Hi!

Aplication => Newsletter => Log:

In table "newsletter" have 2 col named "start_time" and "end_time" seted as timestamp.

When I create new newsletter, "start_time" is automaticly filled with current date and time.

When I send newsletter, I want to fill "end_date" with current date and time.

Tried with php function date(), but date was wrong.
Tried with mySql function now(), but it changes "start_time" and "end_time" to current time.

last query:
$query_string="update nl_newsletter set status=3,user_sent=".$user->id.",end_time=NOW() where id=".$nl_id;

any sugestions?

[_SuperString]

In table "newsletter" have 2 col named "start_time" and "end_time" seted as timestamp.

Dont set "end_time" to timestamp, use a Date type instead. Timestamps are not really for doing this type of thing as far as I know. Check out the MySQL site for more info.

[archangel_617b]

"datetime" is probably the type you want for those columns since "timestamp" is updated by MySQL every time the row is.