View Single Post
Old 20-08-2005, 01:39   #8
punky
Inactive
 
Join Date: Jun 2003
Age: 45
Posts: 14,750
punky has a golden aurapunky has a golden aura
punky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aurapunky has a golden aura
Re: A little SQL help (possibly)

BTW in case you are missing out on something obvious here Raist:

SQL can store carriage returns and whatever you use to query your DB with, can handle it.

For example, you can have a LONGTEXT or VARCHAR in MySql which is linked a textarea HTML element. If you put carriage returns in your textarea, MySql will save them, but when you display them again, say with PHP, HTML takes over and ignores them because it doesn't see <br>s. However, don't forget you can use the <pre> </pre> HTML element tags, which ignores standard HTML formatting so carriage returns are outputted. The <pre> styles can be set with stylesheets or style tags just like any other HTML element.
punky is offline   Reply With Quote