Put this in your html file. I use text type on mysql column data. I use textarea when input the text on html. It has some breakline on the data. Then i echo it on regular html. You can see the result on kopsyahaba.com/index.php
<?php
$order = array("\r\n", "\n", "\r");
$replace = '<br />';
$ambilintro=mysqli_fetch_array(mysqli_query($con,"SELECT * from home"),MYSQLI_NUM);
$databaru=str_replace($order, $replace, $ambilintro[0]);
echo $databaru;
?>
