displaying SQL results

[Craig Hopson]

Hi all, not shore where to start with this one... SQL Table Entry `comments`This is a test line 1This is a test line 2This is a test line 3 The code

echo $row['comments']

The outputThis is a test line 1 This is a test line 2 This is a test line 3 how do i display the output like its stored in the SQL RequiredThis is a test line 1This is a test line 2This is a test line 3

[Ingolme]

Print a line break: In plain text:echo "\r\n";In HTML:echo '<br>'

[Craig Hopson]

No I know that but all 3 test lines are the same entry one field in the SQL

Edited May 10, 2012 by Craig Hopson

[justsomeguy]

http://www.php.net/manual/en/function.nl2br.php

[Craig Hopson]

thank you how would i remove blank lines please

[justsomeguy]

You would either need to use a regular expression or split the text up into an array of lines using explode, loop through it, and remove each item that's blank. http://www.php.net/manual/en/function.explode.phphttp://www.php.net/manual/en/function.implode.phphttp://www.php.net/manual/en/function.preg-replace.php