HTML code displayed in update form translated by browser

[ayswest]

I have a text area that accepts html code into a MySQL database. However, when I retrieve it to review it IE6 translates the code in the text area field.

Example: I type in "18 " Wheels" and when IE displays the info from MySQL it reads "18" Wheels" next time I submit the record it records in the database as 18" and the third I view the record it only diplays "18" and the rest of the information is gone. When the quote is retrieved from My SQL it is perceived as being the end of the parameter.

This same problem exists when I enter some html code. Is there anyway to control the display in the form field so it is not changed by the browser?

[Frederick]

Try:

<textarea name="name" col="10" rows="40"><?php echo HTMLSPECIALCHARS($variable);?></textarea>

[tomhath]

Also read about and understand what an SQL Injection Attack is. You're inviting one if other people can access your form:

http://www.4guysfromrolla.com/webtech/061902-1.shtml

[ayswest]

Thank you, works famously.

By the way, those who have access are only the privileged. The forms are not open to the public. Thanks for the reminder.