Actually, the TEXTAREA tag does capture the line breaks, they get stored in the mysql 
table in a text type column.  When I query the table and re-display the TEXTAREA, the 
line breaks are preserved.  I am using Perl CGI scripts with DBI, DBD-MySQL.

I defined the TEXTAREA (in perl):
<TEXTAREA NAME="portfolio-portdesc" ROWS="5" COLS="65" WRAP="SOFT" > $portdesc 
</TEXTAREA>

The $portdesc is assigned the value directly from the SELECT statement, no fancy 
formatting required.

>Mike,
>         I'm assuming that you are trying to output this to a webpage.
>
>         I think your problem is that, HTML does not use line breaks in the
>document. You can try this out by making a simple webpage like this:
>
><p> A
>B
>C
>D
></p>
>
>         When you view this in your internet browser, you will see:
>
>A B C D
>
>         To insert a line break in HTML, you use a "<br>" tag. In order to have the
>line breaks appear properly in your final document you must insert a "<br>"
>every place the line breaks should appear, and a "</p><p>" at every
>paragraph break.
>
>         In PHP I I have my own funtion to do this, but it would not be that hard to
>make one for Perl or ASP, if that is what you are using. It's just a simple
>search and replace.
>
>function format_text($text){
>         // Change any "<", and ">" their equivalent HTML entities
>         $text = htmlspecialchars($text);
>         // Strip out carriage returns
>         $text = ereg_replace("\r","",$text);
>         // Handle paragraphs
>         $text = ereg_replace("\n\n","</p><p>",$text);
>         // Handle line breaks
>         $text = ereg_replace("\n","<br>",$text);
>return $text;
>}
>
>
>Hope this helps,
>
>Daniel Von Fange
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED]]
>Sent: Monday, January 22, 2001 8:37 PM
>To: [EMAIL PROTECTED]
>Subject: Form Submission
>
>
>When I submit a form and enter it into the database
>it does not recognize when the user presses enter.
>It keeps coming up as one long line, and for poetry,
>it doesn't look very pleasant.
>
>I would love if anyone could help me because it would
>very much help me when creating future projects. I am
>only 16 and I am doing considerably well since the
>person that showed me MySQL said it was too hard for
>me and I will never get anything good done.
>
>But anyways, please help
>
>Mike
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>---------------------------------------------------------------------
>Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to