I want to use <br> tag to show part of data into next line. but unable to do it. can somebody help me to format data. My code is following - <body> <?php $con = mysql_connect("localhost","dwarkapr_archana","reset123"); if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_select_db("dwarkapr_property",$con); $m = $_POST['mode']; echo $m; if($m == "buy") { $sql="select * from dwarka_property where mode = 'buy'"; } else { if($m == "rent") { $sql ="select * from dwarka_property where mode = 'rent'"; } else { if($m=="pg") { $sql="select * from dwarka_property where mode = 'pg'"; } } } //echo $sql; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { echo $row['mode']." "; echo $row['type']." "; echo $row['city']." "; echo $row['budget']." "; echo $row['bedroom']." "; echo $row['properties_from']; <br> }mysql_close($con); ?> </body>
Just add <br> if you are using HTML or <br /> if you are using XHTML at the end of your code like this: while($row = mysql_fetch_array($result)) { echo $row['mode']." "; echo $row['type']." "; echo $row['city']." "; echo $row['budget']." "; echo $row['bedroom']." "; echo $row['properties_from']."<br />"; }mysql_close($con); Regards, Gonzo
try like this.... while($row = mysql_fetch_array($result)) { echo "$row[mode].</br>"; echo "$row[type].</br>"; echo "$row[city].</br>"; echo "$row[budget].</br>"; echo "$row[bedroom].</br>"; echo "$row[properties_from].</br>"; }mysql_close($con);
if you have a string using \n or \r then you can use echo nl2br($string); I know thats not your direct question, just adding it for reference ;D also you can just do one long string like: echo $str1."<br/>".$str2."<br/>".$str3; adding as many as you need too?