Funbrain Games - Winunited Bonuses - Debt Consolidation - Indian television shows news - Debt Consolidation
PDA

View Full Version : how to use <br> tag

kharearch
Mar 11th 2008, 3:36 am
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>
shallowink
Mar 11th 2008, 4:16 am
just put echo "<br>"; Would get better results using a table though.
Gonzo4u
Mar 11th 2008, 4:46 am
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
Kaizoku
Mar 11th 2008, 5:06 am
just echo "<br>";
jaysa
Mar 11th 2008, 5:26 am
u can do it by typing like this

echo '<br />'; in the line where u wrote <br > tag
Namuk
Mar 11th 2008, 5:41 am
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);
dotWdot
Mar 11th 2008, 5:56 am
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?