efficient way to do this?

[xymer]

I have a bunch of database entries created during various portions of the year. I wanted to build an archive page that would basically have a listing of months of the year:
i.e. Sept | Oct | Nov
clicking on any of these would return all the entries from that particular month. My db entries are using a datetime stamp w/ the format yyyy-mm-dd hh:mm:ss

Is there any particular php/mysql functions that would pull entries from only a particular month? or do i have to manually write code to accomplish this?

Thanks for the help.

[[deleted]]

$query = "SELECT * FROM table WHERE MONTH(datefield) = $month";

As long as your links on the months pass through a number 1 through twelve, you'll be set...