Sort by options

[Mike Wilbanks]

I want my users to be able to Sort Categories by Price or Rating. How would I do this?

[Chuck S]

Rating is already there most popular or least popular.

If you want price you need to add a sort to the sort table in mysql

example

Highest Price ORDER BY price DESC
Lowest Price ORDER BY price ASC

[Mike Wilbanks]

sorry, I meant condition, not rating.

[Chuck S]

well condition is rating

[Mike Wilbanks]

I know...the field for "Excellet, Good, etc is called rating, that is why I asked originally about that. I then thought you didn't understand which sort I wanted.

[Chuck S]

Well your emails and your thread here are different so you want to sort by price and sex right.

Well sex is rating so simply rename the sorts in the sort table or make your own

FOR guys ORDER BY disporder,rating DESC

For girls ORDER BY disporder,rating ASC

Price I already posted.