RE: [PHP] Query for MySQL
| From: | Jay Blanchard | Date: | Mon, 30 Jun 2003 18:53:00 +0000 |
| Subject: | RE: [PHP] Query for MySQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-153459@lists.php.net to get a copy of this message | ||
[snip]
I am looking to try and pull the last modified date out and display it.
So
lets say I have 1000 records. I want to only display the date of the
last
modified time, I dont care about the id or the name or anything. How do
I
query for that?
[/snip]
If you have a lst modified date column you would ...
SELECT MAX(LastModifiedDate) FROM yourtable