Pulling all data from specific month

[curb]

I want to pull out all the data entries I've made for a specific month by using a $_GET method (archived.php?month=october). My field time rows look like "1161065143".

How can I do a mysql_query for this?

Here's what I have so far:

mysql_query("SELECT * FROM entrynote WHERE time = '$date' SORTED BY time DESC

[Fumigator]

What type is the time field? (i.e. char, varchar, int, date, time, timestamp, datetime, etc)

[curb]

int(255)

[guelphdad]

I'll guess that it is UNIXTIME you are using there:


select
foo,
bar,
qux
from yourtable
where
month(from_unixtime(yourdatefield)) = 10