Yea, im making a script for a game called Anarchy online, the script searched through a database looking for buffs that increase a certain skill.
I have the user select the skill from a dropdown box on a form and then upon hitting submit the value that they choose is sent to the script as the variable $string. then i have the script do a select statement using like, but i keep getting couldn execute query. here is the query that im using.
$sql = "SELECT ID, Name, QL, Strain FROM $table_name WHERE Modification LIKE "%$string%" ORDER BY QL";
I think the problem is in the LIKE part of the statement, but i cant figure out whats wrong. can someone help me.
