Hi everyone,
I have the following select where I display different rows on my php page, but all the information is together with no space between each row. Can anyone please help me to add spaces between each row?
$host="host name";
$username="username";
$password="password";
$db_name="database name";
$tbl_name="table name";
//<font face="Arial, Helvetica, sans-serif"></font>Connect to server and select databse.
$con=mysql_connect("$host", "$username", "$password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
$db_selected = mysql_select_db("$db_name", $con);
mysql_select_db("$db_name")or die("cannot select DB");
$sql= "select concat(post, post1, post2, post3, post4, post5, post6, post7) as posted from database order by id desc";
$result = mysql_query($sql) or die(mysql_error());
$i = 0;
while ($row_events = mysql_fetch_assoc($result))
{ //loop starts
$events[$i]['posted'] = $row_events["posted"];
$i++;
}
mysql_close($con);