mysql line breaks

flashgroover

im trying to put a few sentences and paragraphs into a MySql database field but my problem is the sentences need to have a space between them or like a return between them.

how do i make mysql accept returns. i am willing to import from excell, access, or notepad.

right now i have each sentence put into seperate fields in a row. i can pull them this way put the way im posting below leaves large spaces on output due to the extra fields that may be empty.

<table>
while ($questions = mysql_fetch_row($result)){

echo"<tr bordercolor='#000000' bgcolor='#00000' height='100'>";
echo"<td></td>";

echo"</tr>";
echo"<tr bordercolor='#000000' bgcolor='#EOEOEO' height='40'>";
echo"<td><h3>$questions[1]</h3></td>";
echo"</tr>";
echo"<tr bordercolor='#000000' bgcolor='#000000' >";

echo"<td> $questions[2] $questions[3] $questions[4] $questions[5] $questions[6] $questions[7] $questions[8] $questions[9] $questions[10] $questions[11] $questions[12] $questions[13] $questions[14] $questions[15] $questions[16] $questions[17] $questions[18] $questions[19] $questions[20] $questions[21] $questions[22] $questions[23] </td>";
echo"</tr>";

}

echo"</table>";

im sure this is totally wrong can someone suggest a sollution?

tijger

hi flashgroover,

if you are working with a textarea the newlines you put in the inputfield will come in the database, but when you print the text you cannot see the newlines. there is a function nl2br() that can help you with that.
when building the text in your php, try the following:

str = "your text with newlines\n";

greetings, tijger

cgraz

YOu could use str_replace before you echo it.

$textarea2 = str_replace("\n", "<br>", $textarea);

echo $textarea2;

Cgraz

devinemke

you don't need str_replace(), as tijger pointed out there is a built-in function called nl2br() which does that very thing.