Help with formatting output

[dvd871]

I'm using a loop to print out data from an array. Need to format output as follows:

| data | data | data | data |
.
.
.
.

Four tables accross and how ever many tables needed down the page. Like this page here: http://www.alighthouse.com/candle.php

[rachel2004]

Do you mean to say 4 cells across or four tables across?

I think I can see what you're trying to get at, but I want to be clear I understand what you're trying to do before hammer out some PHP code.

[dvd871]

I don't think it matters much, cells or tables. I've been beating on this for 2 days now and can't seem to get it to work right. For example, I need 4 cells or tables accross, but what if there is only one entry in the database? or 2 entries? or 3? After there are 4 or more entries I think it wil be more manageable... Any ideas or help is greatly appreciated!

[rachel2004]

It does matter whether you want 4 cells in a row or 4 tables sitting side-by-side because you'd be using a loop to generate either of them. The number of times you loop depends on how many cells you need to fill up. It doesn't make sense to show you a loop that generate 4 tables if want you need is only 4 cells using the <td> tags. Saves me time.

Also, your original post said that the values were in an array, but now you're also talking about databases... be specific on what we're working with and I'll see if I can steer you in the right direction.

Definitely a loop is what you need to solve this, but be clear on what we're working with so I can help you.

If this is an array, it could make a difference what type of iterator you use and we have more knowledge of how many elements are in an array.

[psycorpse]

This would get you four columns and as many rows as needed. I hope that helps and if anyone else has any suggestions feel free to correct me.

Array Style:

$row = array('1','2','3','4','5','6','7','8','9','10');
$num_columns = "4";
$count = "0";
echo "<table border='1'>";
foreach($row as $value){
  $count++;
  if($count == "1"){
    echo "<tr>";
  }
  echo "<td>$value</td>";
  if($count == "4"){
    echo "</tr>";
    $count = "0";
  }
}
echo "</table>";

Database Style:

$sql = "SELECT quote FROM quotes";
$result = mysql_query($sql);
$num_columns = "4";
$count = "0";
echo "<table border='1'>";
foreach($row = mysql_fetch_array($result)){
  $count++;
  if($count == "1"){
    echo "<tr>";
  }
  echo "<td>".$row["quote"]."</td>";
  if($count == "4"){
    echo "</tr>";
    $count = "0";
  }
}
echo "</table>";

[dvd871]

Just what the doctor ordered! LOL! Thanks!

[khjart]

I have a slightly different version.

$cols = 4;
echo "<table border='1'>\n";
$i = 0;
foreach($row as $value){
  if(!($i%$cols)) echo "<tr>\n";
  echo "<td>$value</td>\n";
  if (!(($i + 1)%$cols)) echo "</tr>\n";
  $i++;
}
echo "</tr>
</table>\n";