mysql question: selecting column's values from highest to lowest

[makoy]

Hello phpbuilders. I would like to ask how to select a column's values from highest to lowest. e.g I have a price column which has a value of 10,15,17 and I want to display the values 17,15,10. May I ask how to do that? Thank you in advance.

[jrolands]

Do it in the SQL query, like this:

$result = mysql_query("SELECT columns FROM table ORDER BY column desc");
		or die("Error performing query: " . mysql_error());

[makoy]

Got it! Thank you my friend! 🙂

[jrolands]

Any time dude.. 😉