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

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

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

Boclair

2005-02-21, 3:56 am

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
>
>
>

Sponsored Links