in reply to Re: error in perl with mysql
in thread error in perl with mysql

use $dbh->quote($pdb) instead of '$pdb' in the sql statement

Or, even better, use placeholders and an extra parameter to execute.

$query = 'select * from pdbsummary where pdbid=?'; $exe = $dbh->prepare($query); $exe->execute($pdb);
--
<http://dave.org.uk>

"The first rule of Perl club is you do not talk about Perl club."
-- Chip Salzenberg