Order By Month using time()

[Hylian]

I have a time value in a database for each news post on my site. The time is in the time stamp format (what you get using time() )

I want to allow the user to order the posts by month so they click a link that appears like "May 2003" and it only shows news posts for the month of May in the year 2003. How do I do this when I'm using the time() function to store dates/times?

I'd prefer it be in the MySQL query when I'm retrieving it if possible...

[matt_4013]

SELECT date FROM table WHERE MONTH(date) = 4;

http://www.mysql.com/doc/en/Date_and_time_functions.html

😃