druagord — Mon, 18 Aug 2003 21:57:27 +0000

yes zollet that what it should be

zollet — Mon, 18 Aug 2003 16:03:20 +0000

Shouldn't it be my @rows = $sth->fetchrow_array(); ? And then the result will be stored in $rows[0]

m3rajk — Mon, 18 Aug 2003 14:46:44 +0000

i'm not familliar with how perl interacts with mysql.
does it pull the entire array?

if so, count the array.
if it pulls it one row at a time, is there someplace you can search for a function like php's mysql_num_rows or myysql_affected_rows?

Mark Hensler — Sun, 17 Aug 2003 07:05:13 +0000

I'm not very fluent with perl either. I don't know anything about the perl DBI module.

I believe that whenever you assign an @array to a $scalar, the $scalar then contains the number of elements in the @array.

Busy — Sat, 16 Aug 2003 22:34:08 +0000

I don't know Perl, but what about

count($sql);

or $sth

critical — Sat, 16 Aug 2003 19:37:04 +0000

Well, I guess I don't fully understand how COUNT(*) is supposed to work.

The following code works:

my $sql = "SELECT COUNT(*) FROM groups";

my $sth = $dbh->prepare($sql);

$sth->execute();

my $rows = $sth->fetchrow_array();

$sth->finish;

$rows = the correct number of records matching the SELECT criteria. Is $rows the scalar "size" of an array? If so, what are the contents of that array? Is this the most efficient way to return a count? I can believe it took me two hours to get to this point....