Order list by month questions

Discussion in 'PHP' started by silvercover, Aug 27, 2009.

0
  1. #1
    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:
    2- show items have entered in current month.
    example:
    how can I do that?

    Thanks in Advance.
     
    silvercover, Aug 27, 2009 IP
  2. crivion

    crivion Notable Member

    Messages:
    1,669
    Likes Received:
    45
    Best Answers:
    0
    Trophy Points:
    210
    Digital Goods:
    3
    #2
    what db engine?
     
    crivion, Aug 28, 2009 IP
  3. silvercover

    silvercover Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I figured that I have to use this to get it work properly:

    I use MySQL.

    Thanks.
     
    silvercover, Aug 28, 2009 IP