RE: [PHP-DB] Update time/date stamp

'show table status' will return a record set that you can parse to get the last update time bastien

From: Pete Holsberg <pjh@mccc.edu> To: php-db@lists.php.net Subject: RE: [PHP-DB] Update time/date stamp Date: Wed, 2 Feb 2005 15:00:34 -0500 (EST) On Wed, 2 Feb 2005, Bastien Koert wrote: so select max(last_updated) bastien Error SQL-query : SELECT max( last_updated ) FROM Directory MySQL said: Unknown column 'last_updated' in 'field list' ----------- I see that I was unclear in my description of what I said. My table is called directory. When I open directory with phpMyAdmin, it displays several tables: 1) the structure of directory 2) "Indexes" 3) "space usage", and 4) "row statistic". In the fourth table, it displays the three time-date stamps along with format, number of rows, row length and row size. So the last-updated information is in A table but not the table called directory. Sorry for the confusion.

From: Pete Holsberg <pjh@mccc.edu> To: php-db@lists.php.net Subject: RE: [PHP-DB] Update time/date stamp Date: Wed, 2 Feb 2005 14:06:35 -0500 (EST) On Wed, 2 Feb 2005, Bastien Koert wrote:

is there a timestamp or data time field in the table? If so just quuery that field for the max value select max(dateTimeFieldName) from TableName

No there isn't. When I view the table with phpMyAdmin, it displays a table that includes time/date stamps for creation, last updated and last checked. Thanks. --- Pete Holsberg Columbus, NJ --- "When the people are afraid of the government, that's tyranny. But when the government is afraid of the people, that's liberty." -- Thomas Jefferson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

--- Pete Holsberg Columbus, NJ --- "When the people are afraid of the government, that's tyranny. But when the government is afraid of the people, that's liberty." -- Thomas Jefferson -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php