Find date mysql table last changed

Anon

Everyone :

Using PHP3, is there anyway to find the date the last time a mysql table was changed?

I have Web site I'm developing for a local youth hockey association. One part is an online pratice schedule. I'm finding that the schedule for upcoming weeks may change several times. What I want to do is put next to a "Schedule" link, something like (Last Updated 10/5/00) where the date is the last time the schedule table was updated.

Thanks for the help.

Sincerely,
Dale Williams

Anon

You'll have to add a field like "LastChange" and update it anytime you change the record. You can display this field along with your actual schedule. You'll need to add some code to keep update this field anytime someone changes the schedule.

Anon

Joe :

Thanks for the help. I figured that this would be the answer. I'll just add a last update field.

I was remembering back to a previous life when I was a Clipper/dbase/foxpro developer where there is a function to get last update info on a table. Guess I was just hoping for the easy way out.

Dale

Anon

to elaborate just a little:

you could add a field called 'LastChange' to your schedule table. let it be data type TIMESTAMP so that it is updated whenever other fields in the row are updated. (see http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#DATETIME)

then, to populate the 'last updated' display on your page, you could use a query like:

select max(s.LastChange)
from SCHEDULE s

Anon

Because you want the last -table- change and not the last row change, and because mysql tables are files, can't you just get the file date and time from the actual table file on the file system?

Anon

So if I have a table field called date_changed in my db, and I have a form that takes losts of user input and inserts it into the table like this:

"INSERT INTO TiMH (e_year,e_month,e_day,e_type,event_detail,e_source,comments,contributor,ht_link,flag4error) ".

"VALUES ('$e_year','$e_month','$e_day','$e_type','$event_detail','$e_source','$comments','$contributor','$ht_link','$flag4error')";

How do I get the TIMESTAMP inserted without mismatching the fields? (Since I have no form field for the TimeStamp.)

Code example is always great for comaprison.