RE: [PHP] Need some help with this idea!

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:cuzo@mediaone.net] > Sent: Tuesday, July 24, 2001 8:28 AM > To: php-general@lists.php.net > 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: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >