Hello,

It is highly dependant on the database backend you use, but I guess

my $sth = $dbh->prepare("SELECT * FROM foo");
$sth->execute();
my $num_rows = $sth->rows;
[download]

is what you are looking for. I know it works with MySQL at least. You should check the man page of your database driver (ie. DBD::mysql) to learn more about it.

--
Alper Ersoy