<?php
$Total[01] = mysql_num_rows(mysql_query("SELECT * FROM `tbl01` WHERE $Condition01"));
$Total[02] = mysql_num_rows(mysql_query("SELECT * FROM `tbl02` WHERE $Condition02"));
.
.
.
$Total[10] = mysql_num_rows(mysql_query("SELECT * FROM `tbl10` WHERE $Condition10"));
print_r($Total);
COUNT() can often be faster and use less resources depending on how you use it. I'd suggest studying the differences between COUNT(*) and COUNT(`fieldReference`) in terms of speed.
I had a feeling that SELECT COUNT(*) FROM `tbl01` WHERE $Condition01
would be faster but would SELECT COUNT(`PKey`) FROM `tbl01` WHERE $Condition01
be faster than COUNT(*) ?
mysql> select count(a.id) as count from iris_behaviour_slip as a, iris_students as b where a.studentid = b.id;
+-------------+
| count(a.id) |
+-------------+
| 67336 |
+-------------+
1 row in set (0.34 sec)
mysql> select count(*) as count from iris_behaviour_slip as a, iris_students as b where a.studentid = b.id;
+----------+
| count(*) |
+----------+
| 67336 |
+----------+
1 row in set (0.45 sec)
I had to join the table with something else just so I got a time that was > 0.00secs! a.id is a primary key. So to answer your question it would seem no.