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