Quick newbie question...I am storing dates in my mysql table records, how can i select the record with the most recent date?
bonus question (more of a scripting question)... I need to use perl or php to list the dates out in ranges. in the table they look like: 2002-02-17 2002-02-24 2002-03-02 2002-03-09 2002-03-15 .... what method can i use to list them out in a drop-down menu side-by-side so the user can select the range like so? Select date range: 2002-02-17 to 2002-02-24 2002-02-24 to 2002-03-02 2002-03-02 to 2002-03-09 2002-03-09 to 2002-03-15 2002-03-15 to present any help appreciated! thanks, rory --------------------------------------------------------------------- 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
