commit b4ef48a7e04a3a4a1d201e7a00607fcb37593b12
parent efadab27819106c4dc6d2995c32ee1d73ec6d226
Author: Kyle Milz <kyle@getaddrinfo.net>
Date: Tue, 18 Nov 2014 04:28:23 -0700
price_scraper: scrape vendors in alphabetical order
Diffstat:
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/price_scraper.pl b/price_scraper.pl
@@ -49,7 +49,7 @@ my $prices_sth = $dbh->prepare($sql);
$sql = "update products set last_seen = ? where part_num = ?";
my $products_sth = $dbh->prepare($sql);
-$sql = "select * from vendors";
+$sql = "select * from vendors order by name";
my $vendor_sth = $dbh->prepare($sql);
my $date = time;