escaping characters in text

[mystrymaster]

Alright so I have a text fied that I get input from and I want to echo that information out later.

I get it to enter in the database and echo it out however if the user hits enter in the text area or uses the characters in the parenthesis ( ' " ; : / \ { } [ ] ( ) < > . , ) it chokes.

How do I escape those characters?

Do I need to escape them before inserting them into the database?

[Mordecai]

Try addslashes(). You'll need to add the slashes to escape any time you're using the variable as or in a string, which would include querying the database.

[hkucsis]

You may also need this when you do insert in the db.

mysql_escape_string

[mystrymaster]

cool I shall try those thanks