Counting multiple mysql tables in one query

TimTimTimma

Uhh, i know there is a count() feature and a join feature, but I am not sure as to how I am going to use these i need two simply count the rows from two tables, but need to do it in one query :-)

like mysql_num_rows("SELECT * FROM table, table"); the problem with this is that it multiplies the numbers of both tables together!

bradgrafelman

Just a guess here...

EDIT: Removed my code, as it did the same thing as yours.. multiplied the number. Hehe :p

Shrike

Should be in the database forum...

SELECT COUNT( t1.column1 ) AS t1count, COUNT( t2.column2 ) AS t2count
FROM table1 AS t1, table2 AS t2

bradgrafelman

So the final result could be calculated like so?

$query = mysql_query('SELECT COUNT( t1.column1 ) AS t1count, COUNT( t2.column2 ) AS t2count
FROM table1 AS t1, table2 AS t2') or die(mysql_error());

$totalrows = (int)(mysql_result($query, 0, 't1count')) + (int)(mysql_result($query, 0, 't2count'));