[SOLVED] How to get multiple rows for similar table without 2 queries

[pkedpker]

Was just wondering if it's possible to get 2 rows

 

for like

 

WHERE name = 'test'

and

WHERE name='test2'

 

to return both rows in 1 query.

 

Got this atm

 

SELECT `pid`,`lvl`,`hatch` FROM pet p LEFT OUTER JOIN members m ON m.id = p.uid WHERE m.`name`='$myName' AND p.banked = 0 LIMIT 1

SELECT `pid`,`lvl`,`hatch` FROM pet p LEFT OUTER JOIN members m ON m.id = p.uid WHERE m.`name`='$opponentName' AND p.banked = 0 LIMIT 1

 

now how do i join both together in a single query and i dont want the rows returned to be in a strange order.. but in a order of how it was done first the myName then the opponentName and just get 2 rows?

 

I'm not just asking for a handout i'm asking to learn.. from a example so i dont have to ask again. 

[gassaz]

Maybe, you can use UNION.

[pkedpker]

thanks solved never knew about UNIONs.