upperbid Posted November 18, 2009 Share Posted November 18, 2009 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. Link to comment https://forums.phpfreaks.com/topic/181995-solved-update-mysql-from-textarea-problem-with/ Share on other sites More sharing options...
rajivgonsalves Posted November 18, 2009 Share Posted November 18, 2009 whats your code for the insert and the display Link to comment https://forums.phpfreaks.com/topic/181995-solved-update-mysql-from-textarea-problem-with/#findComment-959959 Share on other sites More sharing options...
upperbid Posted November 18, 2009 Author Share Posted November 18, 2009 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. Link to comment https://forums.phpfreaks.com/topic/181995-solved-update-mysql-from-textarea-problem-with/#findComment-959966 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.