How to get rid of (") and (') ??

[Anon]

I'm stuck. Everything worked fine till I entered " or ' in a field. Database accepted this, but afterwards when displaying records into a drop down list (<select>), I get the following error:

Warning: Supplied argument is not a valid MySQL result resource in /usr/local/www/test/index.php on line 98

So, I think I need to hack those values in a way, before they are written into the database. And I've no idea how to do this. Ereg? Regex? Something else?

For example, if I have

I'm"stupid

I would like to have

Imstupid

afterwards. Also it would be nice if I could replace ' and " with spaces.

TIA
Kristjan

[[deleted]]

Searching helps.

use addslashes() to escape the quotes in your data before you enter it into your database.

[Anon]

... and if want to do replaces you can use str_replace()