apostrophes in sql-queries

[milky_milk]

Hello there.

Do you know how to escape apostrophes in eA-scripts?

For example:

 

 

       query_sql("SELECT `id`  FROM `item_db` WHERE `name_japanese` = '"+.@ITEM$+"'",.@ID);

        if ( !.@ID ) {

 

                mes "There is no such item.";

                close;

        }

 

If .@ITEM 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?

[Euphy]

Escape_sql

[milky_milk]

Escape_sql

Thank you very much. Didn't know about this function.