Ok, this may seem like another dumb question from Sooke, but there seems to be many ways of doing this. (select, count or otherwise)

What is the most efficient way to set a value equal to the number of rows (including nulls) in a table?

Example my $total_categories = $DB->table('Category') blah

and one more thing.... how easy is it to add the "DISTINCT" value to such a count if need be?

Many thanks.

# Normal count
my $total = $DB->table('Table')->count;

# Distinct
my $total = $DB->table('Table')->select( 'DISTINCT(Column)' )->rows;

Just added that to my box of tricks. Thanks Paul.


http://www.iuni.com/...tware/web/index.html
Links Plugins