Re: Mysql syntax error

Since "drain cleaner" is two words, it should be quoted. An easy way to solve this and similar problems is to use placeholders. Something like:

my $sth =$dbh ->prepare("UPDATE products set pname=? and  unit=? and q
+ty=? and cost=? WHERE id = ?");
$sth->execute($pname, $unit, $qty, $cost, $id);
[download]

should do the trick. The question marks are replaced by the values passed to execute. For more information, see DBI.

Are you sure it was a book? Are you sure it wasn't.....nothing?

Comment on Re: Mysql syntax error Download Code

Replies are listed 'Best First'.
Re: Re: Mysql syntax error by dbwiz (Curate) on Nov 10, 2003 at 19:00 UTC
`my $sth =$dbh ->prepare("UPDATE products set pname=? and unit=? and qty=? and cost=? WHERE id = ?");` [download] should do the trick. No. It shouldn't. The SQL syntax is wrong (see meetraz's answer.	[reply] [d/l]