entering data

[Anon]

Hi,

I've got code that lets a user select from a list of books.

The books selected from the list go into a database.

Everything works fine except when the title of one of the books has an apostraphe (') in it.

I am turning the title into a variable (ie: $title="Bob's Adventure") and then trying to insert $title into an sql db.

Anyone no if there is a way to strip apostraphes ? Or if there's another way to get around this problem?

Thanks a lot

R.

[edwardsbc]

Please go here:

<http://www.php.net/manual/en/function.addslashes.php>

Note: if you are using MS SQL you need to double the quote:

'Bob's' becomes 'Bob''s'

This can be done with:

<http://www.php.net/manual/en/function.str-replace.php>