Count help

[Darren884]

Hi I am using the following queries
SELECT * FROM $topics_table WHERE board_id = '{$row2['board_id']}'

SELECT * FROM $replies_table WHERE board_id = '{$row2['board_id']}'

then I do the query results and a mysql_num_count for each then I add them to together with a variable. So there is 1 row in topics table and 1 row in the replies table. Is there anyway to combine these queries? ANy way at all, or is it impossible in mysql?

[r937]

here ya go --

select one + two as four
  from ( 
       select count(*) as one 
         from $topics_table 
        WHERE board_id = {$row2['board_id']}
       ) as five
cross
  join ( 
       select count(*) as two 
         from $replies_table 
        WHERE board_id = {$row2['board_id']}
       ) as seven