Hello all - I have a PHP/MySQL calendar application that, for some reason, stores the date in 3 separate fields: year, month, day. What I need to do now is create a dropdown menu that gets data for each of the next 7 days by day of the week. For example, if today is Monday, selecting Monday from the select/option value dropdown would get data for today... selecting Friday would get data for the next Friday. What would be the easiest way to accomplish this... should I extract 3 variables from date or timestamp and then generate separate queries for each day?? Seems like there should be an easier way. Any help greatly appreciated Tim Wright ::::::::::::::::::::::::::::::::::::::::::: ::: ::: ::: Timothy Wright ::: ::: mailto:[EMAIL PROTECTED] ::: ::: Digital Network Enterprises ::: ::: http://www.01network.com ::: ::: ::: ::: secure e-mail by request ::: ::: (PGP signature and/or encryption) ::: ::::::::::::::::::::::::::::::::::::::::::: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]