using a subquery

[cadkins23]

I'm not sure if what I am looking for is a subquery, etc.

My site currently allows searches by zip code, gender, etc.

I want to make it so that users can select to only show profiles which has a field in photos named xratedphoto = 1. In other words only show profiles with xrated photos.

Since a query is already being built do go through the members table, how can I first query to gather the members who have xratedphotos before I perform the 2nd query on those results?

I hope I explained well enough what I am looking for. 🙂

Thanks in advance,

Chris

[Piranha]

You should not have to use 2 queries, most often the second query is in a loop and then it is much more than 2 queries executed. Show your query and database structure and I'm sure that someone can help you out.