getting last update time of mysql table

[eon201]

Hi,

 

I want to get the time/date that a table was last updated within my database.

 

I know you can put a new column in with a timestamp, but the data is old and obviuosly already exists.

 

I notice that in my mysql admin it shows me this time and date. Is there anyway I can grab this and display it in my html page with php??

 

Thanks guys. Eon201

[rajivgonsalves]

I've heard of of a mysql_insert_id () function but not what you want maybe the gurus in the forum can help you

[Psycho]

SHOW TABLE STATUS

 

http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html

 

There's a return value for Update_time

[rajivgonsalves]

very nice mjdamato learnt another thing today after 4 years of programming in php

[eon201]

Hey thanks! 

 

Sorry to be a pain/noob, but how would I implement the Update_time into this function???

 

Thanks. Eon201

[eon201]

Ok, ive tried it like this...

 

				$mysqlupdate = mysql_query("SHOW TABLE STATUS FROM logtable;");
				echo "Statistics last updated - $mysqlupdate[update_time]";

 

But no luck

 

Have I messed up the syntax???

[pkSML]

Your code needs to look something like this:

$result = mysql_query("SHOW TABLE STATUS FROM table_name;");
while($array = mysql_fetch_array($result)) {
print_r($array); // Will print information about each table stored in database
}

 

$result returns a resource. You need to use one of the mysql php functions to use it.

 

BTW, I'm using InnoDB for my tables, and unfortunately it doesn't record a last update time.

[eon201]

Hey guys,

 

Thanks for all of the help so far on this.

 

Unfortuantly none of the suggested examples work!

 

Has anyone else achieved this before?? Or has any idea on how to go about it?

 

Thanks, eon201