Hey thanks i got it to work sort of
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date DESC LIMIT
3;
that works
but i want it to show them ascending and when i change it to
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC; DESC
LIMIT 3;
it doesn't work
any
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC LIMIT
3;
-Original Message-
From: David Rice [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 2:20 PM
To: [EMAIL PROTECTED]
Subject: Queries help (part II)
Hey thanks i got it to work sort of
$query = SELECT
If you only want it ascending, take out the DESC as in:
$query = SELECT * FROM gigs WHERE date '$today' ORDER BY date ASC LIMIT
3;
- Original Message -
From: David Rice [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 28, 2002 12:19 PM
Subject: Queries help (part II
