alphabetizing a query's results

[Anon]

i'm SELECTINGing * from table ORDER BY itemID DESC LIMIT 8

that gives me the last 8 items

i'd like to alphabetize these 8items by field A -- is this possible within the mySQL query, or do i have to sort the array in php?

[brandonschnell]

yes, its possible.

SELECTINGing * from table ORDER BY itemID,A DESC LIMIT 8

[[deleted]]

Doesn't nate mean:
order by itemID, the grab the last 8, and order those by field A?

[Anon]

you have to sort it in php.

i do this with a 'top recent news' section i have where i sort them by accesses limit to 15 or so, and then sort those by date.

put them all in an array, and then do this:

function cmp ($a, $b) { return ($b[0] - $a[0]); }
usort($array, cmp);

where item 0 in this case is the one you want to sort on.