[SOLVED] Order list by month questions

[silvercover]

Hi,

 

I have list of items in my database with date field in UNIX time stamp format. now I need to:

 

1- show items sorted and grouped by the month they've been entered into my database.

example:

---- January ----

Item 1

Item 2

Item 3

---- February ----

Item 4

Item 5

Item 6

Item 7

2- show items have entered in current month.

example:

---- Current Month Items ----

Item 1

Item 2

Item 3

Item 4

how can I do that?

 

Thanks in Advance.

[ignace]

1. ORDER BY month(timestamp)

2. WHERE month(now()) = month(timestamp)

[silvercover]

Thanks ignace for your tips. I figured that I have to use this to get it work properly:

 

WHERE month(FROM_UNIXTIME(timestamp_field)) = month(now())