mwouters

Hello, 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! Mark.

Hello, I'm trying to create a search using fulltext search, but it does not return any values. I don't get an error when I execute following SQL, but nor a result: [code]SELECT ID AS blogID, titel, tekst, MATCH (titel, tekst) AGAINST ('Belgacom') AS ranking FROM blog WHERE MATCH (titel, tekst) AGAINST ('Belgacom')[/code] I did use a word with more than 5 letters as you can see, and the word does not return 100 times in the text (so it would be ignored).. so it should find a result.. I have MySQL 4.1.18 installed. Can it have something to do with the charset? If I do an export of my table structure I get this: [code]CREATE TABLE `blog` (   `ID` int(11) NOT NULL auto_increment,   `datum` datetime NOT NULL default '0000-00-00 00:00:00',   `titel` text collate latin1_general_ci NOT NULL,   `auteur` int(11) NOT NULL default '0',   `tekst` text collate latin1_general_ci NOT NULL,   `foto1` text collate latin1_general_ci,   `foto2` text collate latin1_general_ci,   `foto3` text collate latin1_general_ci,   UNIQUE KEY `ID` (`ID`),   FULLTEXT KEY `titel` (`titel`,`tekst`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5;[/code] Thanks a lot for any help, I don't know what to do.. Mark.