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@xxxxxxxx> > >To: php-db@xxxxxxxxxxxxx > >Subject: RE: 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