Timestamp auto update ?

[baffled_in_UK]

Hi,

I have the following code to set an account to Inactive.

$sql=mysql_query("UPDATE ads_main SET ads_active ='N'  WHERE ads_expiry < NOW()");

The code "works", however it also sets the value of ads_expiry (a Timestamp field) to todays date. Why is this and how can I stop it ?

Thanks

[xblue]

the manual again...

The TIMESTAMP column type provides a type that you can use to automatically mark INSERT or UPDATE operations with the current date and time. If you have multiple TIMESTAMP columns, only the first one is updated automatically.

you could switch to datetime to prevent this, or set the field to its previous value should work I think:
UPDATE ads_main SET ads_active ='N', ads_expiry=ads_expiry WHERE ads_expiry < NOW()");

[nnichols]

The first TIMESTAMP field in a table automatically updates to the current date/time whenever you run an update.

You can stop it by setting it to itself -

$sql=mysql_query("UPDATE ads_main SET ads_active ='N', ads_expiry=ads_expiry  WHERE ads_expiry < NOW()");

Though if you don't want the autoupdate the field should be changed to DATETIME field.

Hoe this helps 😉

EDIT:
too slow again :rolleyes:

[baffled_in_UK]

Thanks guys