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]

Reply via email to