I have noticed in a couple of topics that people have noted to NOT add slashes to a database.
The last site i worked on had a small database and when i tried to insert any ' into the database it wouldnt have it, so in the end i removed all of these from the data and just put up with it.
However this time the database is HUGE and i will need to have the ' in there.
So my question is: Do i insert data like this:
Code: Select all
INSERT INTO `tablename` (`row1`, `row2`, `row3`) VALUES (1, 'something', 'something with these[color=#FF0000]'[/color]', 'something more')Code: Select all
INSERT INTO `tablename` (`row1`, `row2`, `row3`) VALUES (1, 'something', 'something with these[color=#FF0000]/'[/color]', 'something more')Many thanks for any help.