RE: [PHP] Need some help with this idea!
| From: | Don Read | Date: | Tue, 24 Jul 2001 07:03:28 +0000 |
| Subject: | RE: [PHP] Need some help with this idea! | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-59305@lists.php.net to get a copy of this message | ||
On 24-Jul-2001 Chris Cocuzzo wrote:
> hey-
>
> I want to select the oldest show from a database to display on my main page,
> since the oldest show is also the show happening closest to any current
> time(if that makes sense...). I included a timestamp field in my table of
> shows in anticipation of checking that to find out what was the oldest.
> however, I'm wondering how I should go about doing that exactly. my idea was
> the scan through just that column of timestamps, find the lowest one, and
> then make a selection from the db based on the timestamp. Can any give me
> some examples of code to scan through a column like i mentioned, or give me
> better ideas on how to do this??
>
> thanks
> chris
>
'Old'-est - order by your_timestamp asc
'New'-est - order by your_timestamp desc
... limit x;
Regards,
--
Don Read dread@texas.net
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.