Hi,

i am trying to display data from a mysql database in a HTML table in a certain way, i can get the data to display in a one column list but i require the data to display in a five column five row table, any ideas on how i can go about doing this ?

P.S. i use PHP to call the mysql data.

Thanks,
Mark H.

It's simple, create 5 columns and 5 rows

Think, don't stink

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.

Originally Posted by tripy

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.

Yes something like that, but it can be much easier !