The stupid question is the question not asked | |
PerlMonks |
Re: DBI and MySQLby Kanji (Parson) |
on Jul 12, 2002 at 06:06 UTC ( [id://181218]=note: print w/replies, xml ) | Need Help?? |
As you suspect, it is your (My)SQL syntax and not Perl/DBI at fault here, and can be fixed by removing the second WHERE in your statement because (in simple queries, anyway) you're only allowed one WHERE clause. Something else you might want to do is investigate the use of placeholders (example below), which will automatically quote your variables so they don't break your SQL (ie, if you searched for O'Reilly, you'd have an extra apostophe in your statement!).
Note also the use of die instead of print, so that the script finishes after the first error instead of generating an endless stream of them, potentially confusing things... --k.
In Section
Seekers of Perl Wisdom
|
|