Easiest way to sort by date...

[eluser]Armchair Samurai[/eluser]
I'd do it like this

Code:

SELECT foo
FROM bar
WHERE created >= '2008-01'
AND created < '2008-02'
ORDER BY created ASC