pricecharts

track prices of consumer electronics
Log | Files | Refs | README

commit 52e7d50988374b8f9a6e19ba382bfed601b0f332
parent 36b99fb676531813858c9dd9408d68f0bee7ad38
Author: Kyle Milz <kyle@getaddrinfo.net>
Date:   Mon,  3 Nov 2014 20:02:04 -0700

gen_index: use count() sql query

Diffstat:
Mgen_index.pl | 12++++++------
1 file changed, 6 insertions(+), 6 deletions(-)

diff --git a/gen_index.pl b/gen_index.pl @@ -19,19 +19,19 @@ my $config = { my $template = Template->new($config); -my $query = "select distinct manufacturer from products"; -my $manuf = $dbh->selectcol_arrayref($query); +my $query = "select count(distinct manufacturer) from products"; +my @manuf = $dbh->selectrow_array($query); -$query = "select part_num from products"; -my $products = $dbh->selectcol_arrayref($query); +$query = "select count(part_num) from products"; +my @products = $dbh->selectrow_array($query); $query = "select count(name) from vendors"; my @vendors = $dbh->selectrow_array($query); my $vars = { num_vendors => $vendors[0], - num_manufacturers => scalar @$manuf, - num_products => scalar @$products + num_manufacturers => $manuf[0], + num_products => $products[0] }; $template->process("index.html", $vars, "index.html") || die $template->error();