I have cobbled the following code that when it retrieves the data from Mysql, the data is displayed with no line breaks which results in one large paragraph. I have been trying for quite awhile ....without sucess to get nl2br working with this code. The original data is entered by the user via a textarea form.
Any help would be much apreciated...I am still fairly new at programming and it probably shows... Thanks TD. <?php // set database server access variables: $host = "localhost"; $user = "develop"; $pass = "********"; $db = "bio"; // open connection $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); // select database mysql_select_db($db) or die ("Unable to select database!"); // create query $query = "SELECT * FROM main"; // execute query $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); // see if any rows were returned if (mysql_num_rows($result) > 0) { // yes // print them one after another echo "<table cellpadding=0 width = 100% border=0>"; while($row = mysql_fetch_row($result)) { echo "<tr><font color=blue size =4>"; echo ".$row[1]</b>"; echo "<tr><font color=black size = 3>"; echo ".$row[2]"; echo " <br> \n"; echo " <br> \n"; } } else { // no // print status message echo "No rows found!"; } // free result set memory mysql_free_result($result); // close connection mysql_close($connection); ?>