Well it seems in the new year I needed to modify my blog script a little bit. The archival section that I added was done using arrays and I did not incorporate a function to display the new year. So I managed to create a temporary fix until I can think of a better way to do it.
Right now the script works but looping through an array of years (2007 and 2006) and I have nested another loop inside that goes by the 12 months in the year starting with December and working backwards to January. If the current year matches the currently executed year then run the queries from the most current month to the beginning of the year. I do this so that it will not sure months we have not gotten to yet.
If the main loop is on a previous year then I only display the last 6 months. This is where the script does not quite act the way I want it. The proper way to have the script function would be show the current month and possible the last 6 previous months. I was having trouble wrapping my head around how to calculate this since there are multiple years within the last 6 months.
I’m sure I would need to look at using the PHP function of mktime() but for now I’ll just stick to what I have and work on the rest at a later time.
I’ve noticed that I need to find a better way of displaying my code on the blog here so if anyone can recommend a class that would display PHP, MySQL, Javascript and HTML in a nice colour parsed way I would definately thank you for the link for it.