mySQL Timestamp

In my content news manager I'm developing I'm entering the date of the article into the database via mySQL timestamp.

Is there anyway to get all the articles in a month using this?

Like if I want to get all the articles that are sports related by the address:

category.php?cat=sports

is there a way to do this:

month_select.php?month=jan

By just using the mySQL timestamp?

for january:

SELECT * FROM table WHERE MONTH(timestamp) = 1

Thanks, I assume I can do this:

month_select.php?month=1

SELECT * FROM table WHERE MONTH(timestamp) = '$month'

Originally posted by jbachris
Thanks, I assume I can do this:

month_select.php?month=1
SELECT * FROM table WHERE MONTH(timestamp) = '$month'
[/B]

yes, but you also assume register_globals in ON...which you shouldn't