comment field problems

[Anon]

I have a form with a comment field (named review) where users can type a paragraph or two of text. How can I get this into mysql properly and out properly?

I guess I need to select a special field type or something?

Any help welcome.

Thanks

[Anon]

Check out the MySQL manual to find a field type that suits your needs.
TEXT is usually enough.

When you insert the data into your database, be sure to use something like
addslashes() to escape quotes etc.
And when you read the data from the database, use stripslashes() to get the escape commands back out.

[Anon]

You don't have to use stripslashes when you pull it out of the database. Try it and see.

---John Holmes...