if you date stamp the data input, query that field
bastien
From: boclair <boclair@xxxxxxxxxxxxxx>
To: "php-db@xxxxxxxxxxxxx" <php-db@xxxxxxxxxxxxx>
Subject: Displaying the time of the Latest Update to an ISAM table
Date: Mon, 21 Feb 2005 10:38:12 +1000
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php