[RESOLVED] Count Rows in 2 Tables

transfield

Hello,
I have 2 MySql tables called Table A & Table B respectively. I'd like to sum up the total number rows in both tables & display the results. How do I do this?

I know how to connect to the Mysql database so we can skip that part.

Thanks a lot.

etully

$query = "select * from table_a";
$result = mysql_query($query);
$count_a = mysql_numrows($result);

$query = "select * from table_b";
$result = mysql_query($query);
$count_b = mysql_numrows($result);

$total = $count_a + $count_b ;

print "There are $total rows in tables a and b combined";

transfield

Thank you very much for your guidance, Etully. I appreciate your help.

Piranha

I would not do it in the above way, it requires everything to be read from the database tables. It works if there are only a few rows, but if there are million rows then it would take lots of memory and lots of time to do it this way.

Instead I would do it like below (which is better but probably not the best way). Note, replace "id" in the "COUNT(id)" with your primary key for the table.

$query = "select COUNT(id) from table_a";
$count_a = mysql_query($query);

$query = "select COUNT(id) from table_b";
$count_b = mysql_query($query);

$total = $count_a + $count_b ;

print "There are $total rows in tables a and b combined";

transfield

I appreciate your reply, Piranha.

Yes, I have 6 tables in total & eventually they may contain 1000's of records. At the moment, I don't feel any difference between both the methods but on the long run I think your suggestion will be more efficient.

Thank you once again.