[SOLVED] mysql UNION + count(*)

[phorcon3]

$a=mysql_query("(SELECT Count(id) AS Count FROM `t1` WHERE `this` = '$_GET[text]') UNION (SELECT Count(id) AS Count FROM `t2` WHERE `this` = '$_GET[text]')");
$b=mysql_fetch_assoc($a);

echo $b['Count'];

 

that obviously only gives back the result from t1...but how can i make sure it adds both counts ..from t1 and t2?

[Mchl]

SELECT ((SELECT Count(id) AS Count FROM `t1` WHERE `this` = '$_GET[text]') + (SELECT Count(id) AS Count FROM `t2` WHERE `this` = '$_GET[text]')) AS total

[phorcon3]

thanks!!