[Resolved] Efficient table building

[corruption]

I've got a set of data that i want outputted into an HTML table with 3 columns and however many number of rows it takes for all of the data to be retrieved.

so i hope that it looks something like this in the end..

<tr>
<td>Name1</td>
<td>Name2</td>
<td>Name3</td>
</tr>
<tr>
<td>Name4</td>
<td>Name5</td>
<td>Name6</td>

....

And on and on until there are no more names... Currently i can display them properly with a SELECT statement for each row of data that i want. However doing that is not very efficient especially for 60 people.

I can get one row with every name on it via a different method, or one row for each new person.

Source Code

Display

[planetsim]

So what do you need help with?

[corruption]

The display doesn't come out the way that i want it.

More with the html i guess if it's possible to be done.

I want three names on each <tr></tr> set of tags. currently the only way to do this is to do each row by itself. So i need a more efficient way of doing this. The method shown does not provide me with quite the layout that i want.

I need help getting the three results on a row then advancing to the next row starting with the next result.

I hope that makes sense

[planetsim]

$i=0;
while ($row=mysql_fetch_array($sql)) {
  {
     if (!($i%3)) {
        echo "<tr>";
     }
     $i++;
  }
echo "<td>".$row['name']."</td>";

}

Just change that to work for your code.

[corruption]

thanks for the great help. The code worked flawlessly once i adjusted it for my needs.