Select Code to Download

#! /usr/bin/perl
# wwfindt.pl - Find articles in WW Index databases, return in table
...
$sth->finish;
$dbh->disconnect;
exit (0);

dave@davesdell:~/Perl$ ./wwfindt.pl
WWFindt.pl starting.
...
Name='ShopNotes', Date/Vol/Iss=Sept/Oct, 2007/16/95, Page=4, Title='Ti
+ps for Your Shop'
WWFindt.pl completed processing.
dave@davesdell:~/Perl$

mysql_st_internal_execute MYSQL_VERSION_ID 50137
>parse_params statement SELECT Source.SourceName, SourceDateVolumeIssu
+e.SourceDate, SourceDateVolumeIssue.SourceVolume, SourceDateVolumeIss
+ue.SourceIssue, Article.ArticlePage, Article.ArticleTitle, Article.Ar
+ticleSynopsis FROM (Article, Source, SourceDateVolumeIssue) WHERE (Ar
+ticleTitle LIKE '%saw blade storage%' OR ArticleSynopsis LIKE '%saw b
+lade storage%') AND (SourceDateVolumeIssueId = Article.ArticleSourceI
+d) AND (Source.SourceId = SourceDateVolumeIssue.SourceId) ORDER BY So
+urce.SourceName, SourceDateVolumeIssue.SourceVolume, SourceDateVolume
+Issue.SourceIssue, Article.ArticlePage
...
    <- dbd_st_fetch, 7 cols
    <- fetchrow_array= ( 'ShopNotes' 'Sept/Oct, 2007' '16' '95' '4' 'T
+ips for Your Shop' 'Saw blade storage case; Conduit compass & router 
+trammel; Shop-made gouge block; Circle cutter set-up gauge.' ) [7 ite
+ms] row1 at wwfindt.pl line 47
    -> fetchrow_array for DBD::mysql::st (DBI::st=HASH(0x86c09a0)~0x85
+816f8) thr#857e008

SQL result

...
Wood     Dec/Jan, 2008/2009     25     188     18     Shop Tips     Ex
+tension for blocked drill crank; Pushstick for safer belt sanding; Ea
+sy-to-reach scrollsaw blade storage; Using metalworking clamps for ex
+tended reach; Adding hardboard zero-clearance plate to circular saw; 
+Shoe organizer to store bottles and cans; Economical corner clamps; U
+sing chip cans for storing paint rollers on the job.
Woodsmith     June, 2002     24     141     4     Tips & Techniques   
+  PVC Pipe Clamp Storage; Name that cord; Quicker panels on the table
+ saw; Saw blade storage; Tap & die storage; Laminate liner for shop v
+acuum.
Woodsmith     Dec, 2002     24     144     4     Tips & Techniques    
+ Dangling drawer stops; PVC tool storage; Cork clamping; Mess-free cl
+eaning; Saw blade storage;