Thread: How do i display mysql data in a 5 column 5 row table ?

I'm in a good mood tonight, so:
PHP Code:

<?php
$html="<table>";
$cptLine=0;
$q="select a, b, c from tbl";
$r=mysql_query($q);
while($o=mysql_fetch_object($r)){
if($cptLine===0){
$html.="<tr>";
foreach($o as $key=>$val){
$html.="<th>{$key}</th>";
}
$html.="</tr>";
}
$html.="<tr>";
foreach($o as $key=>$val){
$html.="<td>{$val}</td>";
}
$html.="</tr>";
$cptLine++;
}
$html.="</table>";

echo $html;
?>

Not tested, but you get the idea, at least.

You have several options depending on how fancy you want to get with your HTML/CSS. You can try to keep each to 50% width and float them left and the elements should automatically arrange themselves in two columns. You could probably do it with a Modulus operator which will get the remainder of a devision.