Select Code to Download

 my $name = $cgi->param("name"); 

...
my $sth = $dbh->prepare( "select * from my_db where name like ?" ) or 
+die "DBI prepare: $DBI::errstr";

$sth->execute( %name% ) or die "Couldn't execute statement: $DBI::errs
+tr";

$sth->execute( $name ) or die "Couldn't execute statement: $DBI::errst
+r";

my $sth = $dbh->prepare("
    SELECT blah FROM blah WHERE blah LIKE ?
");
$sth->execute('%foo%');