php variables containing mysql data

Anon

I set up a helpdesk with a html textarea where the user can describe their problem.If their explanation contains an apostrophe, when I pull the data out of the mysql database and put it in a variable to view it, all the text from the apostrophe on is missing. If you look at the record in the database, everything is there so it doesn't seem to be a problem in the database.How come my php variable can't contain all the data from my problem field? I've checked this many times and it only happens when an apostrophe is used.

Anon

Not knowing your exact situation, it sounds like you either have to escape or encode you apostraphies.

Dennis

Anon

You need to go through the text that is inputed and replase all ' with \'

This is because the php parser does something like this

if $text = This won't work

"INPUT INTO table (field_one, field_two) VALUES ('$id', '$text')";

is parsed to

"INPUT INTO table (field_one, field_two) VALUES ('1', 'This won't work')";

Andreas Bernhardsen
Graficonn

Anon

Many thanks.

Anon

Appreciate the help.