Multiple Rowed Columns

[redstar504]

Hello

Say you had a table like this:

<table>
<tr>
<td>Name One</td>
<td>Name Two</td>
<td>Name Three</td>
<td>Name Four</td>
<td>Name Five</td>
<tr>
<td>Age One</td>
<td>Age Two</td>
<td>Age Three</td>
<td>Age Four</td>
<td>Age Five</td>
</tr>
</table>

I want each name and age to be pulled from a sql table. The table consists of 5 peoples names and ages.

Would it be best to call it from one statement, such as this:

$statement = "SELECT * FROM table";

And use a while() loop inside the HTML table? Or would it be best to use multiple select statements and number each one? I'm using this on a site where it will be selecting upwards of 100 rows, that would be alot of select statements.

Can someone guide me in the right direction? 🙂

[laserlight]

You just run one select statement, then implement the logic in PHP to divide the rows of the result set into rows of your HTML table.

[redstar504]

Any ideas what that logic might be?? thanks

[laserlight]

Loop with a counter and start a new row everytime the counter is a multiple of 5. You also need to cater for the case where the total number of rows in the result set is not also a multiple of 5.