$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 * 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 thoughts? _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php