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