Small issue with sorting query results.

[Solarpitch]

In the below code I am simply trying to sort a list of results in the category "Drivers" by price. I can achieve this fine but it only seems to take the first 2 digits of the price when sorting, so...

 

Instead of sorting like:

 

€38

€70

€125

€175

€250

€370

 

Its sorts like:

 

€125

€175

€250

€370

€38

€70

 

$limit = 'LIMIT ' .($pageno - 1) * $max .',' .$max;
$query = "SELECT * FROM ads WHERE category = 'Drivers' AND validation = 0 ORDER BY '$price' $limit";
$result = mysqli_query($mysql_connect, $query) or die (mysqli_error($mysql_connect));

 

[redking]

$query = "SELECT * FROM ads WHERE category = 'Drivers' AND validation = 0 ORDER BY '$price' $limit";

 

should be

 

$query = "SELECT * FROM ads WHERE category = 'Drivers' AND validation = 0 ORDER BY price DESC $limit";

 

where price is the name of your price field in the database

DESC = descending order

ASC = Ascending order

[Solarpitch]

No, still hasnt resolved the issue.  :-\ Its really strange, I dont think theres anything wrong with the query itself.

[zampu]

$query = "SELECT * FROM ads WHERE category = 'Drivers' AND validation = 0 ORDER BY price DESC 10, 0";

or

$query = "SELECT * FROM ads WHERE category = 'Drivers' AND validation = 0 ORDER BY price DESC 0, 10";

[BlueSkyIS]

it looks like you're storing the prices as strings, including the Euro symbol. the database is sorting the strings in proper order. don't store numbers as strings.

[syntaxerror]

i believe php has specific sorting functions for in a 'human' sense

natsort()

 

i think

 

it might come in handy