milky_milk Posted February 19, 2014 Share Posted February 19, 2014 Hello there. Do you know how to escape apostrophes in eA-scripts? For example: query_sql("SELECT `id` FROM `item_db` WHERE `name_japanese` = '"[email protected]$+"'",[email protected]); if ( [email protected] ) { mes "There is no such item."; close; } If [email protected] is "Gentleman's Pipe" - I've got errors in MySQL: : DB error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Pipe'' at line 1 Can you help me? Quote Link to comment Share on other sites More sharing options...
Euphy Posted February 19, 2014 Share Posted February 19, 2014 Escape_sql 1 Quote Link to comment Share on other sites More sharing options...
milky_milk Posted February 20, 2014 Author Share Posted February 20, 2014 Escape_sql Thank you very much. Didn't know about this function. Quote Link to comment Share on other sites More sharing options...
Hello there.
Do you know how to escape apostrophes in eA-scripts?
For example:
If [email protected] is "Gentleman's Pipe" - I've got errors in MySQL:
Link to comment
Share on other sites