Table in Mysql date

[dagon]

Is there any way to get the date that a mysql table was last modified ?

with a flat file i use to just get the file date.

[cgraz]

Uou'll need a timestamp field that was stamped when the last change was made. Besides that, there's no way of doing it as far as I know.

Cgraz

[dagon]

Thanks for the reply i found a way:

$info = mysql_fetch_array(mysql_query("show table status from databasename like 'tablename'"));
$table_date = $info["Update_time"];