A minor correction:

my $sth  = $dbh->prepare( "select * from clients where name like ?" );

$sth->execute($name) or die "Whoops!"
[download]

That should be $sth->execute("%$name%") or somesuch use of wildcards in the execute.