View Full Version : Sort by options
August 9th, 2005, 04:02 AM
I want my users to be able to Sort Categories by Price or Rating. How would I do this?
August 9th, 2005, 08:30 AM
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
Highest Price ORDER BY price DESC
Lowest Price ORDER BY price ASC
August 9th, 2005, 09:37 AM
sorry, I meant condition, not rating.
August 9th, 2005, 10:39 AM
well condition is rating
August 9th, 2005, 10:55 AM
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.
August 9th, 2005, 11:17 AM
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.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.