ORDER BY price desc

morleymouse · 02-12-04

any reason why 'ORDER BY price desc' wouldnt order the products by price, from highest to lowest in a my sql query?

because it isnt...

yes the column name is 'price'

the full query is jus select all from my table where something = something and this works fine as its showing products, then it has the order by price and them a limit 0,30

all works part from the prices, which just seem random

any ideas

giveasyouget · 02-12-04

umm.. is there an index on the price (should only slow it down, not prevent it from working though)

is the price field a float/integer or is it a varchar? should be a float to get things working properly, or it will order things differently.

ianm · 02-12-04

If it's a VARCHAR you'd get something like this

4
30
3
2
100
10
1

999gi · 02-12-04

That'd be my thought too
If youve got it as a text type of field rather than a numeric field then itll be sorted alphabetically rather than numerically like

1
111
12
2
21
22398437598324
234
3

etc.

morleymouse · 02-12-04

it was varchar, silly me

thanks