Line Spaces in MYSQL & PHP

[artisticre]

Below is my code. When I run this, the data for $row[coach] is one long parahraph unless I enter <br> or <p></p> in the database itself. Is there a way to breakup the paragraphs at run time instead of putting it in the database for each entry?

$db = mysql_connect("xxx", "xxx", "xxx");

mysql_select_db("xxx",$db);

$result = mysql_query("SELECT * FROM coaching where (title = '$TitleList')",$db);

if ($row = mysql_fetch_array($result)) {

do {

echo (" <table border=0 width=75% align=center>
<tr>
<td class=coachtitle>$row[title]</td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td class=coach>nl2br($row[coach])</td>
</tr>
<tr>
<td class=author>$row[author]</td>
</tr>
<tr>
<td align=center><a href=/coaching.html>Back</a></td>
</tr>

");

} while ($myrow = mysql_fetch_array($result));

echo ("</table>");

[chasiv]

how are you going to know where the paragraphs end if you don't save it to the database?

maybe I'm just not understanding properly, but it sounds like you want the information in $row[coach] in linebreark or paragraph format. If so, you need to know where you want the paragraphs to start and/or end.

You could manipulate the field with str_replace() at a later point, but that may not give you the effect you want.

[artisticre]

I am entering the data through a web panel. Currently I am putting <p></p> after each line but this is time consuming. I was just wondering if I could enter into the database with the line breaks by hitting Enter and then have it displayed correctly.

This is what I need it to look like

---

With whom can you share your joys and sorrows?

Whom can you phone without having a reason?

We have a range of emotions and sharing them doubles the good emotions and cuts the bad ones in half. Emotions always get better, therefore, through sharing.

Identify the handful of people you can share your feelings with and put them on speed dial!

[chasiv]

check this out:

nl2br() — Inserts HTML line breaks before all newlines in a string

If the field is a textarea input field, it should be storing the linebreak.. so just adding the function should display it the way you want.