PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Classifieds Suggestions (http://www.photopost.com/forum/classifieds-suggestions/)
-   -   Sort by options (http://www.photopost.com/forum/classifieds-suggestions/115205-sort-options.html)

Mike Wilbanks August 9th, 2005 03:02 AM

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

Chuck S August 9th, 2005 07: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

example

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

Mike Wilbanks August 9th, 2005 08:37 AM

sorry, I meant condition, not rating.

Chuck S August 9th, 2005 09:39 AM

well condition is rating

Mike Wilbanks August 9th, 2005 09: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.

Chuck S August 9th, 2005 10: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.


All times are GMT -5. The time now is 04:04 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97