so select max(last_updated)
bastien
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php