Enc0der

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!