Search by additional profile field?

[Robert Basil]

I am looking for a way to search by an added profile filed (i.e. $userinfo[field3])

I have tried a few things using the memberlist.php for reference, but no luck.

Any hints?

bump.

I'm also interested in doing the same thing. i would like users to be able to search by city and state.

So I am guessing that this cannot be done?

I'm not asking that someone do this for me, just point me in the right direction. :)

I'm not going to write this one, but this should give someone enough to be getting on with... // $searchstring is acquired from a form
// $fieldnumber is the number of the custom field you are searching with.
// it would probably come from a form too...

$users = $DB_site->query("
SELECT user.*, userfield.* FROM user
LEFT JOIN userfield ON (userfield.userid = user.userid)
WHERE userfield.field".addslashes($fieldnumber)." LIKE(\"%$searchstring%\")
ORDER BY user.username");

while ($user = $DB_site->fetch_array($users)) {
// do what needs to be done to build the page bits
} This code snippet will perform a simple text match against a custom user field - so if you were searching with $fieldnumber = 2 (Location) and $searchstring was "New", then it would pick up all users from New York, Newcastle etc...