<![CDATA[vldPersonals Forum - Search multiple fields = how?]]> http://www.vldpersonals.com/forum/topic/8149/search-multiple-fields-how/ Tue, 13 Jul 2010 01:21:34 +0000 PunBB <![CDATA[Search multiple fields = how?]]> http://www.vldpersonals.com/forum/post/40012/#p40012 I've got a unique site - I'll give you a good example. It's a hookup board where people can choose different locations they want to meet people. For free, you can select up to 2 states. For bronze membership, it's up to 4, silver 5 and gold 6.

There is no way that I can see where I can have a checkbox of 20 locations and have users be able to select only up to x number based upon their membership so my idea was creating a locations field and using ti six times. So it will be:

Location 1: <dropdown of 20 locations>
Location 2:  <dropdown of same locations>
Location 3: ....

Is there a way in VLD (there has to be a query modify) where you can have search show up for Location 1 but include an OR statement so that it would be

If stateselected = location1 or location2 or location3... THEN return YES.

This way in the search, finding the location in any of the six field entries returns a positive result. I think this is useful in many ways but is probably not the norm for most. smile

PS - Also Tried to get hold of Ramil or someone to do custom programming as well but doesn't look like he's around or just too busy with projects!

]]> Tue, 13 Jul 2010 01:21:34 +0000 http://www.vldpersonals.com/forum/post/40012/#p40012