Jump to content

[SOLVED] UPDATE mysql from textarea problem with ">


upperbid

Recommended Posts

I am having a problem with a MYSQL update from a textarea box.  Here is what happens, if I type in:

 

<FONT face="Verdana">

 

then hit submit, it saves correctly, but returns this when I view it in a form textarea box:

 

" ><FONT face="Verdana">

 

After a lot of trial and error, I narrowed it down to:

 

">

 

then hit submit, it saves correctly, but shows below in the textarea box:

 

" >">

 

Anybody got any tips on how I can display this correctly.  I already tried strip slashes, mysql_real_escape_string, htmlentities, trim and none of those work.  By the way, in case it matters, I have magic quotes on.

 

Any help would be appreciated.

As I already said, it saves fine, so the insert code is irrelevant.  It saves exactly what it should to the database (exactly what I input).

 

As for the display code, it is a simple select statement and I have removed all additional manipulations of the retrieved data to that for now since none of them worked on solving the problem.  It happens from a simple select and while display.

 

Since writing this, I have also discovered that this does the same thing in a text input box as well as textarea.

 

It also sends this same weird text to the webpage, too.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.