[Bill Thebert]

Originally Posted by gmarik

Not bad. Would be nice to have a search by varfield as well, for example, Location (the city, I mean).

I would like to see yet another variation on this theme.

I would like to see the "Advanced Search" form (for searching the FORUMS, not just the memberlist) include one or two of the custom user profile fields.

Practical example:

Four of my forums are used for classified advertising.

Two custom fields in the user profile are CITY and STATE (separated, rather than the combined "Location" field).

I would like to include these two fields next to the USER NAME field in the Advanced Search form, such that my users could search, for example, as follows:

"Display all threads/posts in one or all (4) of the Classified ad forums, posted by users from Colorado, for the word 'widget'."

Or find a transmission in Dallas, or an axle from someone named Joe in Kentucky, etc. (My site is automotive-related, obviously.)

The Advanced Search form is alredy doing a cross-table query, right? Selecting posts from one table, based on info from a separate user table?

I would happily hire someone for such a hack.

Regards,

Bill