What wrong with my DBI?

[luke Peng]

Hi All,
Can anyone give me a hand by finding where is the problem when call mysql from perl in a small program.

I just simply do the selection

$myquery = "SELECT * FROM $tablename";

it works fine. After I add the where clause

$myquery = "SELECT * FROM $tablename WHERE ligand_name = $l_name";

the $l_name = "UMT"; was defined.

A ERROR message pop out as follow

DBD::mysql::st execute failed: Unknown column 'UMT' in 'where clause' at /usr/lib/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/Mysql.pm line 175.

Can anyone give me a hint what wrong?

Thanks

Luke



Edited 2 time(s). Last edit at 08/07/2007 04:02PM by luke Peng.