Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Including html textarea enter/newline characters into SQL query

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0

I've got this HTML textarea that represents a bulletin message, but any enter/newline characters in the textarea are immediately discarded as a result of the construction of the MySQL query. The query goes something like this:

UPDATE myTable set Message=textAreaName WHERE .......

I was wondering whether someone knows how to retain all input enter/newline characters in the textarea so that the MySQL query accounts for them.

Thanks in advance!
 
Is it PHP you use, that can be pushed into retaining everything by use of single quotes.
______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top