Hi could someone help out a non-perl programmer with this statement:
I want to set $num_cats = SELECT COUNT(Depth) FROM lsql_Category WHERE Depth=$count;
$count is from my for loop.
Here is what I have so far:
my ($num_cats) = $DB->table('Category')->select(['COUNT(Depth)'])->fetchrow_array;
Thanks!
I want to set $num_cats = SELECT COUNT(Depth) FROM lsql_Category WHERE Depth=$count;
$count is from my for loop.
Here is what I have so far:
Code:
my ($num_cats) = $DB->table('Category')->select(['COUNT(Depth)'])->fetchrow_array;
Thanks!