select * from whatnot order by timestampcolumn desc limit 1
if the "limit 1" doesn't work with your db, just fetch the first result
only...
greets,
remo
> -----Original Message-----
> From: Chris Cocuzzo [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, July 24, 2001 8:28 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Need some help with this idea!
>
>
> 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
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
