ORDER BY question

[techrat]

$cmd = "SELECT $field, sum(1) as count FROM $table1 WHERE $category = '$type' GROUP BY $field";

I am using the code above to count answers on a survey sheet.
The sheets have two types of questions with the answers ranging from 0 to 5 or from -2 to 2.

They currently sort all answers in descending order,
I want to sort the answers (-2 to 2) to sort in ascending order. Is there something like an IF statement that I can add to end of the query to achieve this? Because I dont want to have to run a separate query to find if the smallest answer is a negative number.

Techrat

[tomhath]

I'm pretty sure the answer to the question you asked is "yes".

But you didn't give anywhere near enough information for anyone make a reasonable guess at what the solution would be.

They currently sort all answers in descending order,
I want to sort the answers (-2 to 2) to sort in ascending order.

Who is "they"? What answers? All your query does is count rows.

Maybe this is what you want, maybe not, I have no clue:

SELECT $field, answer
FROM $table1
WHERE $category = '$type'
order by
case when $field = 'Ans1' then -answer
else answer
end