The objective is to sort data from a mysql database.
There is a database by year.
shape 2011_history, 2010_history ...
Day in each table column are from 1 to 365. (Or 366 leap year)
The sorting must be provided:
- Depending on the user (id_account)
- Customization of the date. (Example: from 10/09/2011 to 13/09/2011)
- Order by group.
data display and are the number of each table the user has the date indicated.
I provide the structure and the screen shot of a scoreboard.
The MySQL function must be highly optimized, Caril is a lot of data.
I need a complete script with some functional form.
Thank you for your proposal.