Jump to content

[SOLVED] list echo


DarkPrince2005

Recommended Posts

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]";
}?>

Link to comment
https://forums.phpfreaks.com/topic/118772-solved-list-echo/
Share on other sites

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";

Link to comment
https://forums.phpfreaks.com/topic/118772-solved-list-echo/#findComment-611527
Share on other sites

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 :)

Link to comment
https://forums.phpfreaks.com/topic/118772-solved-list-echo/#findComment-611530
Share on other sites

<?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>";

}

 

}?>

Link to comment
https://forums.phpfreaks.com/topic/118772-solved-list-echo/#findComment-611535
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.