Hello!
I'm currently making a website with some news/articles on a mysql database.
Every item is stored with a 'date' column, in unix timestamp format.
I have no problem, of course, to get the time in the desired format, like this: $time = date('F j, Y, G:i', $time);
The problem is I want to make a monthly-archive.
What I need is a two things:
1. a function that will get the months of the items, and create the archive-links - with something like "?month=XX" (or maybe "?month=XX&year=YY" ?).
Something that will look like this:
November 2005
October 2005
September 2005
etc... and every link will show the items of that specific month:
2. a function (I believe it's just a sql-query, actually) that will get all the items from a specific month only. Remember that's every item have a 'date' as a unix timestamp..
Do you have any idea on how to make that in an efficient way ?
Thanks!