RE: [PHP-DB] Displaying the time of the Latest Update to an ISAM table
| From: | Bastien Koert | Date: | Mon, 21 Feb 2005 02:41:42 +0000 |
| Subject: | RE: [PHP-DB] 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-38623@lists.php.net to get a copy of this message | ||
if you date stamp the data input, query that field
bastien
From: boclair <boclair@bigpond.net.au> To: "php-db@lists.php.net" <php-db@lists.php.net> Subject: [PHP-DB] 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