Returning data from a table by year
Posted: Fri Jul 31, 2009 9:47 am
Hi,
Any insight into the following would be good.
I have a MySQL table with data going back several years. I wish to retrieve the data from the table in year order but in recordsets of years & months.
So I wish to query the table and bring back the current year data, broken down by month and insert each month's records into an HTML table but each month to have its own table.
Jan 2009
record 1
record 2
record 3
Feb 2009
record 4
record 5
record 6
record 7
March 2009
record 8
record 9...and so on
Any insight into the following would be good.
I have a MySQL table with data going back several years. I wish to retrieve the data from the table in year order but in recordsets of years & months.
So I wish to query the table and bring back the current year data, broken down by month and insert each month's records into an HTML table but each month to have its own table.
Jan 2009
record 1
record 2
record 3
Feb 2009
record 4
record 5
record 6
record 7
March 2009
record 8
record 9...and so on