Hi guys, i am trying to sort my products by price
$query = "SELECT * FROM data ORDER BY price";
It doesnt seem to sort it by the highest/lowest number
eg
1000 200 250 30 3000 3050
Anybody know whats wrong with my query?
Is it a text/varchar type field?
its a char field
that's why.... change it to an int field and it'll work...
thankyou very much!
