Re: Select COUNT in MySQL

[dbwiz]

in reply to Select COUNT in MySQL

Alternatively, you may use selectrow_array to get a single value.

my ($crows) = $dbh->selectrow_array($sqlc);
print $crows;

Notice that $crows was declared in list context, to avoid side effects.