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