On 6/17/02 5:18 AM, "Alex Elderson" [EMAIL PROTECTED] pressed the keys forming
the message:

> Hi,
> 
> Is it possible to get the time of the last change of a mysql table?? in php?

Sure.  Try this:

$info = mysql_fetch_array(mysql_query("show table status from dbname like
'tablename'"));
echo "Last update for tablename: ".$info["Update_time"];

Enjoy.
-- 
Ed Marczak
[EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to