Hi,

I'm using a field called cb_geozip (zip code). I'd like to be able for the current logged in user to see a list of members 'like *my* cb_geozip'.

I'm guessing this can be done with the advanced filter, but I don't know how to code it.

</plea for help>

Thanks!

*bump!*

anybody?

just using "CB advanced search" component and activate the zip field to search for.

than the users can search for every zip code they want.

OMG i'm a GURU now!?

Oh, oh, OH! Yes you are!

Thank you!!

I REALLY LOVE THIS THREAD

OK you guys, I have a question on this one.

I am using CB 1.2 and have set up a field called Favourite Music.

Lets say that I have added the following into the Favourite Music Tab

Rolling Stones, The Jam, Coldplay

OK, now I know that I can set this field as searchable, and then create a list that allows users to search on this field.

But here is the thing, I want to set up an automated list that will search the Favourite Music field for matches with other users.

In other words, I want to have a link called "find users with similar tastes in music" that when clicked on by a logged on user, will automatically generate a list of other users that also have any or all of Rolling Stones, The Jam or Coldplay. I also want these users listed in order of highest amount of matches first.

Any SQL guru's out there that can help?

Kind regards

Gary