PHP MYSQL update statement

arcmax

I have a table XYZ which has two fields
1) date_create, (timestamp(8)), null
2) date_access , timestamp(8), null

and a couple ofo ther fireds including reg_key

I have statement being generated in php

Update XYZ SET date_access=NOW(), no_access=1 Where (reg_key = 'AAAAAAAAAAAAAAAA')

Basically updating only the date_access if there is a reg_key match.

The trouble is that the the date_create field is getting updated along with it...I would like to know what am i doing wrong and how to set it right...any ideas?

thanks
apurva m

xblue

that is what mysql timestamps are meant to do: auto-update.
apart from that, they are much like datetime fields.

11.3.1.1 TIMESTAMP Properties Prior to MySQL 4.1
11.3.1.2 TIMESTAMP Properties as of MySQL 4.1

since only the first timestamp column is auto-updated by default, it may help to change their order, but to me it seems more consistent to use date or datetime data types for the column you do not want to get updated.