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

2005-02-20 Thread boclair
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

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

2005-02-20 Thread boclair
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

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

2005-02-20 Thread Bastien Koert
if you date stamp the data input, query that field bastien From: boclair [EMAIL PROTECTED] 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

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

2005-02-20 Thread [EMAIL PROTECTED]
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