Re: Displaying the time of the Latest Update to an ISAM table

[boclair <boclair@xxxxxxxxxxxxxx>]

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