How can I perform a MYSQL search query that returns two different sets of results at the same time?

[eluser]XMadMax[/eluser]
Dandy_andy,

Best method would be making a UNION between both selects.
Example: http://heybigname.com/2009/09/18/using-c...ubqueries/

Also, you can make a direct query:

SELECT * FROM members WHERE sex='female' LIMIT 6
UNION
SELECT * FROM members WHERE sex='male' LIMIT 6