count 2 table at one go

advan


$countAd = $db->select( 'SELECT count(admin.id) as adminCount,
                                        count(clients.id) as clieCount
                                        FROM admin, clients' );
        $row = $db->fetch( $countAd );

    $adcount = $row['adminCount'];
    $clcount = $row['clieCount'];

Anyone know whats wrong with this code? This 2 code returns 0. I should have 1 record in admin.

ereptur

hmmm, I've tried something similar with one of my databases and it is actually returning the product of the two values multiplied as both results!

advan

multiplied?!? 😕

No wonder I've got 0 as result: 1x0 = 0!

If anyone have a work around for this, greatly appreciated. Thanks for the info ereptur. I think currently I just have to use 2 query to accomplished that. I can't imagine if I were to count 20 tables.