I am building a system that will monitor mortgage policies indefintiely from the date they are added to the system. I therefore want to be able to see on a monthly, quarterly, yearly and bi-yearly basis how many mortgages were sold and by which advisers within the company.
When the policies are added to the database, they are added with the ( day its added) date along with the month number and year.
policy_added = 20061201
policy_added_mon = 12
policy_added_yr = 2006
Now i know how to manually add a select statement to see all of these policies by looking at thsi older question = http://www.experts-exchange.com/Web/Web_Languages/PHP/Q_21596727.html?query=archive&topics=103&showAll=true
But as the months and years go on i want the archive to build itself. Starting by a page where you select the timeframe you want to see
You then select the year and then the month
year and then quarter 1,2,3 or 4
But as a new month and in turn quarter and years go by i need these to automagically add to the archive links.
Any advice would be greatly appreciated!! Cheers :)