Jim R Posted November 21, 2023 Share Posted November 21, 2023 level is the column in question of the query. Right now I have order by -level. Quote Player, level Mark, 5 KJ, 2 Zach, NULL Tony, NULL Jim, NULL I want it to be... Quote KJ, 2 Mark, 5 Zach, NULL Tony, NULL Jim, NULL I tried... order by -level desc ...when I do that, it push KJ and Mark to the bottom. Am I going to have to dig into this with CASE? Quote Link to comment https://forums.phpfreaks.com/topic/317466-sorting-issue/ Share on other sites More sharing options...
Solution Barand Posted November 21, 2023 Solution Share Posted November 21, 2023 ORDER BY level IS NULL, level Quote Link to comment https://forums.phpfreaks.com/topic/317466-sorting-issue/#findComment-1613022 Share on other sites More sharing options...
Jim R Posted November 21, 2023 Author Share Posted November 21, 2023 22 minutes ago, Barand said: ORDER BY level IS NULL, level I saw an example of that, but it had braces around field and blanked out my page. Thank you! Quote Link to comment https://forums.phpfreaks.com/topic/317466-sorting-issue/#findComment-1613023 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.