Last changed record

[V0oD0o]

Hi there,

Is there a MYSQL function whereby it will give me the ID of the last changed record?

I know that mysql_insert_id will give me the ID from the last INSERT query, but I wondered if there was a way to ak the DB, at any time, not just after a query, which the last modified record was.

Thanks in advance.

Mike Pearce

[Lars_Berg]

No there isn't.

[malbera]

insert in your table(s) a colum modify_date and use it

hope that helps

[Mega]

Originally posted by malbera
insert in your table(s) a colum modify_date and use it

hope that helps

yup thats the best method.