20-08-2005, 03:42
|
#9
|
|
Inactive
Join Date: Jun 2003
Location: Los Angeles, CA
Age: 47
Posts: 6,343
|
Re: A little SQL help (possibly)
Quote:
|
Originally Posted by punky
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.
|
Sounds like he's using MSSQL to me though...
|
|
|