Re: Displaying the time of the Latest Update to an ISAM table
| From: | boclair | Date: | Mon, 21 Feb 2005 01:37:25 +0000 |
| Subject: | Re: Displaying the time of the Latest Update to an ISAM table | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38622@lists.php.net to get a copy of this message | ||
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