newbie warning - how to get next seven days data from separate year, month, day fields

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:tim.wright@01network.com ::: ::: Digital Network Enterprises ::: ::: http://www.01network.com ::: ::: ::: ::: secure e-mail by request ::: ::: (PGP signature and/or encryption) ::: :::::::::::::::::::::::::::::::::::::::::::