<pre> formating when pulling data from a mysql database

[portabletelly]

Ok so Im not to sure if this is the right thread to post in but here is my catch 22 issue.

 

I have a test web page www.aandstech.com.au/test.php

 

Test.php pulls its content from a my sql table.

This works fine.

 

When I pull down the info without

<pre>code to retrieve data from mysql database</pre>

tags I loose all my formating ie carraige returns. However the justify works fine.

 

When I use my

 <pre> 

tages to retrieve data from mysql database the carrige returns are fine however the text goes right accross the entire page and not within its div.

 

I have made some headway into resolving this issue by using

<pre width="80"></pre>

However this fix looks fine in firefox 3 but has absoultley no effect in ie6 through to 8.0.

 

Anyway heres a snippet of my code any help would be greatley appreciated.

[color=red]<div class="body">

			<p>	<?php
						$db =mysql_connect("localhost", "******", "*******");
					mysql_select_db("*****_*****",$db);
					$result = mysql_query("SELECT * FROM ***** WHERE id = 1",$db); 

					while($myrow = mysql_fetch_array($result)) 
						{ 
							echo "<pre width='80'>";
							echo "<font face='Lucida Sans Unicode' size=2>";
							echo $myrow["data"]; 
							echo "</font>";
							echo "</pre>";

						} 

				?>
			</p>

			</div>[/color]

 

Another thing is that Im using css and any text pulled from a table doesn't use the css thats why I had to put the fonts in.

 

[mrMarcus]

what is the reasoning for the <pre> tags?  and lose the <font> tags since the are set to be eliminated from HTML .. i also noticed you have a link in the footer stating that your site contains valid XHTML, but it clearly doesn't at 53 errors.

[portabletelly]

Managed to fix it.

 

while($myrow = mysql_fetch_array($result))
{
//echo "<pre width='80'>";
echo "<font face='Lucida Sans Unicode' size=2>";
echo nl2br($myrow["data"]);
echo "</font>";
//echo "</pre>";

}