COUNTING total records from many tables
Posted: Wed Mar 08, 2006 10:47 pm
Any idea which one would be faster or consume less resources ?
Code 1:
Code 2:
Thanks
Code 1:
Code: Select all
<?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);Code: Select all
<?php
$Res_01 = mysql_query("SELECT COUNT(*) FROM `tbl01` WHERE $Condition01"); $Row_01 = mysql_fetch_row($Res_01); $Total[01] = $Row_01[0];
$Res_02 = mysql_query("SELECT COUNT(*) FROM `tbl02` WHERE $Condition02"); $Row_02 = mysql_fetch_row($Res_02); $Total[02] = $Row_02[0];
.
.
.
$Res_10 = mysql_query("SELECT COUNT(*) FROM `tbl10` WHERE $Condition10"); $Row_10 = mysql_fetch_row($Res_10); $Total[10] = $Row_10[0];
print_r($Total);