Selecting from two tables with one query and finding out how many each hit?

[onedumbcoder]

is it possible to select elements from two table at once, and find out how many hits each revcieved?

 

for example

 

select from male, female where name='mike';

 

$countmales = mysql_affected_rows(male);

$countfemales = mysql_affected_rows(female)?

[bilis_money]

yes you can use JOIN for this case.

 

and what do you mean by hits exactly?