[siemens15]

Hello, I have this script :

Code:

    $query.="WHERE u.level >=7 ";
    $query.="AND u.level <=10 ";
    $query.="ORDER BY u.id_level DESC, u.id ASC";

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 ?

[wirehopper]

Hope these are helpful.

MySQL :: MySQL 5.1 Reference Manual :: 3.6.4 The Rows Holding the Group-wise Maximum of a Certain Field

MySQL :: MySQL 5.1 Reference Manual :: 11.3 Control Flow Functions

You might want to read all the data into an array, then modify the user_levels / sort on them. Might be easier than trying to get it out of SQL.

Good luck.