ORDER BY

[portabletelly]

Hi im trying to get a list of priorities in reverse order. Is there a command which is directly opposite to ORDER BY

 

Currently I have several calls (rows) in the data table with priorities ranging from 1, 2, 3, 4

Calls with a priority of 1's are diplayed at the top of my page and 4 at the bottom. My problem is I need them in the opersite order can this be done in the select statement. I thought there might have been some kind of ORDER BY REVERSE statement or somthing.

 

This is my query.

$query_get_calls ="SELECT * FROM data WHERE TechID ='$techid' ORDER BY priority";[code]

[/code]

[gabeg]

Lowest to Highest

$query_get_calls ="SELECT * FROM data WHERE TechID ='$techid' ORDER BY priority ASC";

 

Highest to Lowest

$query_get_calls ="SELECT * FROM data WHERE TechID ='$techid' ORDER BY priority DESC";