MYSQL ORDER

[jaymc]

I have the following fields in a DB

group
gender
username

I want the data to be ordered by the group, then by gender, then by username AZ

My aim is to have people in the highest group at the top but for people in the same group I want to have them orded by gender and then by username..

ORDER BY `group`, `gender`, `username` ASC doesnt work..

[fenway]

It definitely does "work"... give an example.

[jaymc]

$query='SELECT * FROM '.$prefix."_online WHERE ($timestamp-rtime)<20 ORDER BY `group`, `gender`, `username` DESC";

[The Little Guy]

Try this:

$query='SELECT * FROM '.$prefix."_online WHERE ($timestamp-rtime)<20 ORDER BY `group` DESC, `gender` DESC, `username` DESC";

[fenway]

Well, yes, if you want each to be descending, then you need to specify it... it defaults to ascending.

[jaymc]

I dont mean it doesnt output the correct results, I mean, i get no output at all

[The Little Guy]

This will check for any errors

$query='SELECT * FROM '.$prefix."_online WHERE ($timestamp-rtime)<20 ORDER BY `group`, `gender`, `username` DESC";
$sql=mysql_query($query)or die(mysql_error);

[jaymc]

Thanks

Solved