Re: Need some help with this idea!

you bring up something I've been wondering about, can I fetch just a single row to output? chris ----- Original Message ----- From: Remo Pini <remo.pini@pini.org> To: <php-general@lists.php.net> Sent: Tuesday, July 24, 2001 11:13 AM Subject: 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 > > > > > > > -- > 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 >