Last database update....

[Anon]

Hello,

I have an area where members can go in and update a database but I want to be able to know when the last update was made...what do I need to do to keep track of the last update?

Thanks a lot!
-Kevin

[[deleted]]

Depends on how accurate you want it to be.

A simple method is to add a new column to the tables being updated, and always update that column to todays date and time.

If you need more precise details, you'll have to create a logging table and insert information about the updates in there (time,date, which record, who updated it,e tc)