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