Help with ORDER

Discussion in 'PHP' started by a4kata, Aug 6, 2009.

  1. #1
    Hello, I have this script :
        $query.="WHERE u.level >=7 ";
        $query.="AND u.level <=10 ";
        $query.="ORDER BY u.id_level DESC, u.id ASC";
    Code (markup):
    Because I can't change user's levels I want to order first u.level 9 then u.level 8 then u.level 10 ( instead 7 ) and u.level 7 after 10 how ?
     
    a4kata, Aug 6, 2009 IP
  2. premiumscripts

    premiumscripts Peon

    Messages:
    1,062
    Likes Received:
    48
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Untested:

    ORDER BY FIELD(u.level, 9, 8, 10, 7);
    Code (markup):
     
    premiumscripts, Aug 6, 2009 IP