Post data

[XxDxX]

Hello,

I am trying to display data from a mysql database and output it into an html table. So I am basicallly trying to create a news system. I already have a script to output the data on a webpage, I am just trying to put this data in a html table.

How can I format this output in a html table?

Here is my script:

<?php
$db=mysql_connect("localhost","chatspea","");
mysql_select_db("chatspea_news", $db) or die (mysql_error());

$result = mysql_query('SELECT * FROM `postnews` LIMIT 0, 10');

while($row= mysql_fetch_array($result)){
echo"<hr>";
echo "Subject:";
echo $row['Subject'];
echo "<br>";
echo "Author:";
echo $row['Author'];
echo "<br>";
echo "Date:";
echo $row['Data'];
echo "<br>";
echo "Message:";
echo $row['Message'];
echo "<br>";
}
?>

Thanks,
Dylan Alllingham

[LarsLai]

hi!
what is the problem? you already use html tags like <br>, so just use table tags... for example:

<table>
 <?php 
$db=mysql_connect("localhost","chatspea",""); 
mysql_select_db("chatspea_news", $db) or die (mysql_error()); 

$result = mysql_query('SELECT * FROM `postnews` LIMIT 0, 10'); 

while($row= mysql_fetch_array($result)){ 
echo"<tr><td>"; 
echo "Subject:"; 
echo $row['Subject']; 
echo "</td><td>"; 
echo "Author:"; 
echo $row['Author']; 
echo "</td><td>"; 
echo "Date:"; 
echo $row['Data']; 
echo "</td></tr><tr><td colspan='3'>"; 
echo "Message:"; 
echo $row['Message']; 
echo "</td></tr>"; 
} 
?>
</table>

[XxDxX]

Thanks,

Everything looks fine, but when I try to add a border it will not show up. I know this is not a html forum, but I really need this to work.

[Roger_Ramjet]

<table border="1"> gives a thin solid border, "2" is thicker etc

Try these links:

style sheets
html 4.0
html 4.1

for the full specification on tags and style sheets.