Does anyone familiar w/mysql database queries know how I would modify the search query to return results which also include the user location field?

so if they type "black hats texas" it will search the forums for "black hats" and then match that up with people who have their location set to texas that posted in that thread. I'm sure it's a database query modification but not sure how to define it.

Thanks to anyone who may be able to help on this query.

Best Regards,

Marc

It couldn't be as simple as putting "black hats texas" into one field, and have the search know to search the posts for only "black hats" and the location for only "texas". It would have to be two separate fields.

Also, speaking from experience, just "texas" might not work...some members would use "TX" in their profile instead of "Texas", for example.

Couldn't the user field be joined to the tables already in the search? If not and there was a second box added next to the current search box like:

"and location is in"

How would such a "combined" query be formed?

I figured out how to search location on the member.php form but to add it to this is a little over my head so far.

It would be ok for users to do texas or tx. They will have to know to try both ways as with all the countries and provinces we use I can't standardize the location fields.

has anyone done this yet and if not could somebody devise the query or code to add this?

Thanks