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 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]
>
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 anticipatio
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 a
4 matches
Mail list logo