Hello, I run the web site for a band, and I am currently working on the shows list for the band. I have all of the shows listed in a database right now. I don't want to remove the shows that occurred in the past, but instead I want to have a query find only the shows that occur in the future. I have the date of each show in a MySQL date field, formatted as such: year-month-day (2002-07-17). Is there a way to use a query to compare the show date to the current date and only return future events? I'm using PHP to pull the information into the shows section.
Erick --------------------------------------------------------------------- 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