MySql: Count number of rows from multiple tables in a single query

[vishalraj9]

Hi all.
I am trying to count the number of rows from multiple tables in a single query based on criteria. For example, say I have 2 tables, books & bags but based on certain type of a book & certain type of a bag. Now I want to count the number of rows in books table & the number of rows in bags table, all in the same query. I tried some queries like the following:

$sql    = "SELECT  count(*) FROM $books AS books_rows, (SELECT  count(*) FROM $bags AS bags_rows) WHERE books_rows.book_id = '$book_id' AND bags_rows.bag_id = '$bag_id' AND bags_rows.available = 'y'  AND (bags_rows.in_stock = 'y' OR bags_rows.color_available = 'y' OR bags_rows.sold_out = 'n') GROUP BY books_rows.on_id, bags_rows.post_id ";

$result          = mysql_query($sql) ;

// I tried different ways of query, like:
$rows = mysql_fetch_array($result);
 $sql_data = mysql_fetch_row($result); 

Nothing really seems to get me the count from the 2 tables in the same query depending on the criteria. Can some one please suggest a solution?

Thank you in advance.