I am currently developing my very own who's online script for my site and I came across a small problem. Everything so far works just perfect apart from the fact that my query information isn't going my way. I am trying to create it so names are ordered by name and level. For example level 1 is administrator and level 0 is normal user. I wish for it to show admins first aswell order by the name. It is very complicated to explain this but is there any way of ordering in a query twice like:
$sql = "SELECT * FROM online WHERE time <> '0' ORDER BY name AND ORDER BY level";
Please help? Thanks!
Query Problem!
Moderator: General Moderators
-
malcolmboston
- DevNet Resident
- Posts: 1826
- Joined: Tue Nov 18, 2003 1:09 pm
- Location: Middlesbrough, UK
- launchcode
- Forum Contributor
- Posts: 401
- Joined: Tue May 11, 2004 7:32 pm
- Location: UK
- Contact: