$sth = $dbh->prepare("select count(*) from table_one");
$sth->execute();
$row1 = $sth->fetchrow_array;

$sth = $dbh->prepare("select count(*) from table_two");
$sth->execute();
$row2 = $sth->fetchrow_array;

##</code><code>##

$db->query('select count(*) from table_one')->into($row1);
$db->query('select count(*) from table_two')->into($row2);

##</code><code>##

$db->select(table_one => '*')->into($row1);
$db->select(table_two => '*')->into($row2);