Help With Member Search

[hobbybox]

im going to be doing a small advertising campaign on my site. I want a link that can list all the members that choose a certain item in one of the custom profile fields. the list reuslts are going to be by state.

i have setup a custom profile field that indicates what st someone is in. I want to setup a link that will list all the members (memberlist) that are in a certain state - im going to do this for all the states.

I just need help as to what I need to call up to get the results im looking for.

this is the link that comes up when I do a Advanced Search by the state field

http://www.mysite.com/forums/memberlist.php?do=getall

It just doesnt give me any clue as to what parameter I need to show the members from the state.

[Dismounted]

[sql]SELECT *
FROM user
LEFT JOIN userfield USING (userid)
WHERE fieldX = 'Value'[/sql]

[hobbybox]

Thank you for the reply - but im looking for a member link that would display this info.

For example - if a member clicks on 'Connecticut' the link would use the Advanced Search from memberlist and just list the members that have CT as that custom profile field. the more I think about it it doesnt seem like it would be a simple link that can do this.

[Dismounted]

You would have to create a modification that can do this for you, I do not think that functionality exists in a default installation of vBulletin (although I may be wrong, as I have not really delved into the search code).

[hobbybox]

thats what I was thinking - thank you.