Jump to content


mysql needs respect!!

  • Please log in to reply
1 reply to this topic

#1 glenelkins

  • Members
  • PipPipPip
  • Advanced Member
  • 760 posts
  • LocationBridlington - East Riding of Yorkshire - United Kingdom

Posted 22 June 2006 - 03:56 PM


I have a script that enters text from a textarea field into a TEXT field in mysql. When i take the value out it shows without the line breaks...how can i get mysql to respect the line breaks from the text box, and then outputting the same
http://thewebsolutionprovider.com - A Solution For Everything Web!

#2 wildteen88

  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 22 June 2006 - 03:59 PM

You'll want to use a function called nl2br to convert you line breaks into HTML line breaks. The problem is with the browser and not the database. The browser ignores whitespace chars so you need to use nl2br to convert your newline chars into html line breaks

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users