ORDER BY x THEN BY y

Discussion in 'PHP' started by onlyican.com, Feb 28, 2006.

  1. #1
    Hey guys

    I been working hard on a new forum,
    How do I do a mysql query to order by x then by y

    Cheers

    On the note of the forum

    I am building my own one first, which has no admin,

    then I will work on a full version to sell, I will post when completed.
     
    onlyican.com, Feb 28, 2006 IP
  2. vectorgraphx

    vectorgraphx Guest

    Messages:
    545
    Likes Received:
    16
    Best Answers:
    0
    Trophy Points:
    0
    #2
    sql = "select your_fields FROM your_table where your_field = 'your_variable' ORDER by x asc, y asc"
     
    vectorgraphx, Feb 28, 2006 IP
  3. onlyican.com

    onlyican.com Peon

    Messages:
    206
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thanks

    Stupid moment, just found out.

    Cheers anyway
     
    onlyican.com, Feb 28, 2006 IP