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
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
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]
you bring up something I've been wondering about, can I fetch just a single
row to output?
chris
- Original Message -
From: Remo Pini [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 24, 2001 11:13 AM
Subject: RE: [PHP] Need some help with this idea!
select * from whatnot
4 matches
Mail list logo