pricecharts

commit 6b58fa9daced77658733519c7d6c4fd304930b14
parent 78c6045d6acea03ade3564c6c8d04885af3ff944
Author: Kyle Milz <kyle@getaddrinfo.net>
Date:   Mon,  4 May 2015 23:52:58 -0600

pc_html: only generate product pages for products with prices

Diffstat:
M
pc_html
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/pc_html b/pc_html
@@ -122,7 +122,7 @@ generate_folder($stale_list, $types, $products_fine, "Types", $summary,
 #
 print "info: products: " if ($args{v});
 
-my $sql = "select * from products $where_stale";
+my $sql = "select * from products, prices where $part_equality $and_stale";
 my $products = $dbh->selectall_hashref($sql, "part_num");
 while (my ($part_num, $row) = each %$products) {
 	my $part_link = linkify($part_num);