I have seen many articles on this, and none are working for me. I have this code -
$var1->{reference} = sql_get_rows();
sub sql_get_rows(){
etc
return ($sth->fetchall_arrayref());
};
What I want to do is know how many rows are found in the SQL statement and stored in $var1->{reference} (or be told a better way to approach the problems. I have written what $var1->{reference} is storing below.
warn Dumper ($var1->{reference});
'$VAR1 = [
[
26412502,
'initial'
],
[
49246682,
'title'
],
Note that I know how to find the COUNT by an SQL statement, thats not what I want to know.
Thanks