sort() help

[slj90]

I have a page that displays data from a table, however I want to be able to sort it in order of price (hi > lo) and (lo > hi).. how would i do this? is it a query  ?

 

The price field is called 'Price'

 

The query i'm using at the moment to display the data is

 

$query = "SELECT * FROM Product WHERE ProductC = 'Beer' "; 

 

Thanks for your help!

[Buddski]

$query = "SELECT * FROM Product WHERE ProductC = 'Beer' ORDER BY Price ASC";

or

$query = "SELECT * FROM Product WHERE ProductC = 'Beer' ORDER BY Price DESC";

[oni-kun]

ASC and DESC would help, I 'think' this is correct:

 

SELECT * FROM Product WHERE `ProductC` = 'Beer' ORDER BY Price DESC

 

EDIT: Beat to it.