Hi All,I'm trying to add data to my mysql database, however, I received a SQL syntax error because sometimes my string variable contains single quotation mark (').
Does anyone know how to cope with it? My statement is below:$dbh->do("INSERT INTO table1 values(id, '$_', '$t')") foreach sort keys %temp;
Many many thanks! Nan -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
