On Tue, 24 Jul 2001 15:57, 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

I'm not exactly sure what you want here, but it seems like you could do a 
select where timestamp (<= or >= ) NOW() and then ORDER the result ASC or 
DESC according to your needs.

Frinstance, to get the first show on or after today you could select 
where timestamp is greater than or equal to NOW(), ORDER by timestamp and 
LIMIT 1 to get the earliest in the future. Which might be today! You can 
do some fancy formatting of the timestamp in Mysql, if that helps.

David Robley      Techno-JoaT, Web Maintainer, Mail List Admin, etc

   Only cosmetologists give make-up exams.

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]

Reply via email to