[Seldimi]

Hello, I am searching for a way to count rows from more than one table in my database.
I use for counting one table :

Code:

$sql = "SELECT * FROM wplanet_freestuff";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
echo "$num";

What to use for counting 10 tables ???
Please Help

[afkaar]

for me, idon't know function that count from or than a table. but in this case i'll do the folwing:
make an array of ur tables list :

Code:

$tb[1]="table1";
$tb[2]="table2";
$tb[3]="table3";
$tb[4]="table4";
for($i=1;$i<=4;$i++){
$sql = "SELECT * FROM $tb[$i]";
$result = mysql_query($sql);
$num[$i] = mysql_num_rows($result);
$nm+=$num[$i] ;
}
echo"$nm";

[ermau]

Why put a variable in quotes? This code is much more effecient:

PHP Code:

$tb = array(1   => 'table1',

            2   => 'table2',

            3   => 'table3',

            4   => 'table4');

$rowTotals = array();



for ($i=1; $i<count($tb); $i++)

{

     $request = mysql_query('SELECT COUNT(*) FROM '.$tb[$i]);

     $rows     = mysql_fetch_row($request);

     mysql_free_result($request);

     $rowsTotal["$tb[$i]"] = $rows[0];

} 

That will give you the ammount of rows for each individual array. It's much more effecient to do the query for the count, rather than query everything. $rowsTotal contains every table's rows, the key is the table name. The for loop is also dynamic so that if you add any to the array it will compensate automatically.

[alesh.ru]

PHP Code:

list($all[$i]) = mysql_fetch_row(mysql_query("select count(*) from $table")); 

it's faster

[ermau]

It's not really all that different, and you still have to run it through a loop. It's also more confusing to the newbs and just harder to read in general, that's why I didn't do something like that.

[Seldimi]

Thank you