[SOLVED] list echo

[DarkPrince2005]

I've got a field in my mysql database that stores a product discription listin all its features, but when i echo it it returns it all in one line instead of each other, but when i echo it in a textarea it displays correctly. How can I fix this?

 

<?php
mysql_connect("localhost","root","");
mysql_select_db("products");
$sql=mysql_query("select * from tbl_product where product_id like '$_POST[product_id]'");

while ($row=mysql_fetch_array($sql)){
echo "$row[description]";
}?>

[alin19]

try

<?php
mysql_connect("localhost","root","");
mysql_select_db("products");
$sql=mysql_query("select * from tbl_product where product_id like '$_POST[product_id]'");

while ($row=mysql_fetch_array($sql)){
echo "$row[description]"."\n";
}?>

 

[wildteen88]

try

<?php
mysql_connect("localhost","root","");
mysql_select_db("products");
$sql=mysql_query("select * from tbl_product where product_id like '$_POST[product_id]'");

while ($row=mysql_fetch_array($sql)){
echo "$row[description]"."\n";
}?>

 

New lines (\r\n \n or \r) are not displayed, you need to use the <br /> tag to display a new line.

echo "$row[description]<br />\n";

[DarkPrince2005]

nope, that doesn't work

[alin19]

try

<?php
mysql_connect("localhost","root","");
mysql_select_db("products");
$sql=mysql_query("select * from tbl_product where product_id like '$_POST[product_id]'");

while ($row=mysql_fetch_array($sql)){
echo "$row[description]"."\n";
}?>

 

New lines (\r\n \n or \r) are not displayed, you need to use the <br /> tag to display a new line.

echo "$row[description]<br />\n";

 

yes you're right i use cli and confuse them

[DarkPrince2005]

the value in that field are: eg. Celeron 1.5GHz, 512MB RAM, LCD Monitor, etc.

 

I want it to be displayed:

 

Celeron 1.5GHz,

512MB RAM,

LCD Monitor,

 

instead of

 

Celeron 1.5GHz, 512MB RAM, LCD Monitor

 

[alin19]

<?php

mysql_connect("localhost","root","");

mysql_select_db("products");

$sql=mysql_query("select * from tbl_product where product_id like '$_POST[product_id]'");

 

while ($row=mysql_fetch_array($sql)){

 

$x=explode(",",$row[description]);

 

foreach ($x as $Y)

{

echo $y." </br>";

}

 

}?>

[DarkPrince2005]

thanx alin19, that works perfectly