i want sort online user and i used one WHERE guest = '0' (just reg users)
there is 3 Level :
level 2 : God Admin
level 3 : moderator
level 1 : normal user
I want sort users online :
First : God Admin [level 2]
Two : moderator [level 3]
Tree : normal user [level 1]
$ListOnline = $db->sql_query("SELECT w.uname, w.module, w.url, u.user_id, u.user_level, u.user_allow_viewonline FROM Table_session AS w LEFT JOIN Table_users AS u ON u.username = w.uname WHERE guest = '0' ORDER by user_level DESC, user_id ASC");
From what I gather, you want to order your data, and you want to order it neither in ascending or descending order. So you need to either change the indexes on which you are ordering or create a new index to order on, from which you would be able to order ascending or descending.