Quotes pb

[jamal_dakak]

Hi ,
Can you help me with this problem. I try to add a product with the name containing double quotes but it's causing an error.
This is a query:

SELECT ID FROM Products WHERE LOWER(Name) = LOWER("1/2" ITT Pharmaceutical Diaphragm valve")
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 'ITT Pharmaceutical Diaphragm valve")' at line 1

How can I escape this string?

Thanks

[devinemke]

SELECT ID FROM Products WHERE LOWER(Name) = LOWER('"1/2" ITT Pharmaceutical Diaphragm valve')

[jamal_dakak]

Not sure because on php this a query I'm using:
$dbq = db_q("SELECT ID FROM Products WHERE LOWER(Name) = LOWER(\"".db_e($add_product["Name"], -1)."\")");
db_e is a function wich escape string(mysql_real_escape_string)
And also the same pb will be if I'm inserting a product with a single quote 😕