Any Way to Pass a variable into a MYSQL Query with Local Database

This would be for the end users in the front end.

-Eugene

I am looking at creating a large number of charts. For each of these charts I will need to have the data displaced by current/previous week, month, and year. So if I have 10 base charts in order to cover all of these time frames I would need to create 60 charts.

With that said is there a way to have a single chart where I can pass into it the changes that are necessary to display the data by the specified time frames.

For example I have an orders by store chart. I then could select within the cart current week to display the same data but for the current week, or previous week to display the data for the previous week, current month, previous month, and so on.

Regards,
-Eugene