my ($count) = $dbh->selectrow_array("SELECT COUNT(id) FROM table");