help needed to display the contents of table in proper format.

sanoop

Can some body guide me about how to display the contents of the MySQLTable, keeping the formatting same. For eg. In my table I have a colum called COLUMN. In that the data is input as shown below.
"XXXXXXXXXXXX.
1. yyyyyyyyyy.
2.zzzzzzzzzz."

But when I am trying to display the contents, the display comes as follows
"XXXXXXXXXXXX.1. yyyyyyyyyy.2.zzzzzzzzzz."

I need it to be displayed as it is stored in the table.

Any help is greatly appreciated.....

Houdini

How about showing the code you use to produce the output you are trying to expaing above?
Without seeing what you have done it would be hard to give a real good answer that would really be helpful.

sanoop

Please find below my coding. I have tried to reduce it as small as possible, since it is very long. My problem is when I am doing an echo of the coloumn Question, I am getting it out of format as shown in the earlier post... Any suggestions???

<?php
/ Connecting, selecting database /

// get the total number of records

  $page1 = $_GET['by'];

  $page = $page1 ;
 if ($page < 1) {
 $page = 1 ;

}
$limit = 2;
$sort = ((($page-1) $limit) ) ;
$result = mysql_query("SELECT DISTINCT count( ) FROM Teasers WHERE 'Sl no' <> '0'");
$num = mysql_result($result, 0, 0);
$total = ceil($num / $limit);

$offset = $sort ;
/ Performing SQL query /
$query = "SELECT DISTINCT Question FROM Teasers WHERE 'Sl no' > \"$sort\" LIMIT $offset, $limit ";
$result = mysql_query($query) or die("Query failed : " . mysql_error());

/ Printing results in HTML /
?>

<?php
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
if (($x % 2) == 0) {
?>
<TR><td bgcolor="#C8DBDF">
<?php
}
else {
?>
<TR><td bgcolor="#CCCCCC">
<?php
}
echo "$x".") " ;
echo "".$line['Question']."" ;

echo " ";
$pass = ($x + ($page - 1) $limit) ;
$save = $page ;
$save .= "" ;
$save .= $pass ;
echo "<a href='/answers.php?by=".$save." '>Click here for answer</a>";

?>
</td></TR>
<?php
$x++;
if ($x==20){
$page++;
}
}