Data Display - (rows/columns)

[The_PHP_Newb]

I need a 4x4 table in a while loop. I have been doing standard data display (per row) for quite some time. Now I need something that looks like this:

data_a1 data_b1 data_c1 data_d1
data_a2 data_b2 data_c2 data_d2
data_a3 data_b3 data_c3 data_d3
data_a4 data_b4 data_c4 data_d4

Can someone provide a snippet?

Please assume I'm familiar with if/while, etc. If this is an array, I'm not too familiar but I learn extremely quickly by looking at existing (sample) code.

Thanks Much!

[teyeheimans]

<?

$array = range(1, 16);

$columns = 4;

echo "<table>\n";
for($i = 0; $i < count($array); $i++ ) 
{
    if($i == 0)
      echo "  <tr>\n";
    elseif($i % $columns == 0)
      echo "  </tr><tr>\n";

echo "    <td>".$array[$i]."</td>\n";
}
echo "  </tr>\n</table>";

?>

[The_PHP_Newb]

This is what I now have but I can't figure out how to get the data (item, price, color, size) into the table. I tried directly into the <td> and I also tried playing with the $array(). Any additional help would be appreciated.

• $search = mysql_query("select * from table");
  $result = mysql_num_rows($search);
  if ($result > 0) {
  while ($data = mysql_fetch_array($result)) {

  $item=$data[column_1];
  $price=$data[column_2];
  $color=$data[column_3];
  $size=$data[column_4];

  $array = range(1, 16);
  $columns = 4;
  print "<div align=center><center><table border=0 cellspacing=0 width=95%>\n";
  for($i = 0; $i < count($array); $i++ ) {
  if($i == 0)
  print "<tr>\n";
  elseif($i % $columns == 0)
  print "</tr><tr>\n";
  print "<td width=25% align=center>".$array[$i]."</td>\n"; }
  echo "</tr>\n</table></center></div>";

  } else { print "no data to display"; } }

[doobster]

The problem is your information $item, $price, $color, $size is not being stored in the array $array which is what you are outputing here: print "<td width=25% align=center>".$array[$i]."</td>\n"; }

Not sure if this will work but you could try the following:

$search = mysql_query("select * from table"); 
$result = mysql_num_rows($search); 

if ($result > 0) { 

while( $row = mysql_fetch_array( $result ) )
       $array[] = $row;

$columns = 4; 

print "<div align=center><center><table border=0 cellspacing=0 width=95%>\n"; 

for($i = 0; $i < count($array) / $columns; $i++ ) { 
    if($i == 0) 
        print "<tr>\n"; 
    elseif($i % $columns == 0) 
        print "</tr><tr>\n"; 

    print "<td width=25% align=center>".$array[$i]."</td>\n"; 
 } 
 echo "</tr>\n</table></center></div>"; 

} else { print "no data to display"; }

[The_PHP_Newb]

Thank, I actually have it working in a horizontal mode vs. the information stacked vertically in 4 columns. It looks fine and I'm going to leave it as is.

I appreciate the responses! THANKS!