When I insert a word in mySQL which contains a single quote, I escape it using addslashes($word);
When I do an export of my database I get this:
VALUES (2, 'kleuter', 'Gods\\'' dienst',
When I try to get it out of the database I don't get any results using:
SELECT * FROM `uitgaven` WHERE leermiddel='Gods\' dienst'
It looks like mysql escapes the \ and the quote seperately???
How can I get this to work?
Thanks a lot!
Problem with single quotes in mysql
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users