Re: [PHP-DB] Displaying the time of the Latest Update to an ISAM table

[boclair]

Typo. Sorry.  Should read of course
SHOW TABLE STATUS UPDATE_TIME
Louise

boclair wrote:

PHP 4.3.10
MySql 4.0.20

How do I find and then display on a web page the time that additional data added to, or, existing data amended in an ISAM table?

My latest futile attempt , with connection made and the database already selected,

<?PHP
$logged = mysql_query("SHOW TABLE TABLE UPDATE_TIME from  members");
if (!$logged) {$logged="not found";}
else {$logged=$logged;}
?>
<p>Last logged: <?PHP =$logged;?></p>

With no errors reported, the display is "not found".

Louise