Hi Monks,

I want to find the quickest possible way to count the number of rows in a mysql db.

Heres part of my code that returns this "ARRAY(0x1ae8674)"

    my $sqlc = "SELECT COUNT(*) FROM company_info";
        my $crows= $dbh->selectrow_arrayref($sqlc);
            print $crows;

#I did not use prepare or execute since I heard selectrow_arrayref wra
+ps it around
[download]

I also tried using print $crows[0], but then it says it requires global symbol @crows.

What am I doing wrong?

Since this code and sql statement will only generate 1 row returned with 1 column--would selectcol_arrayref be better then selectrow_arrayref ?

Thanks