MySQL Query in HTML tables

thekidscareya

I have a query, $query, and I display the data using a simple

while($row = mysql_fetch_array($query))
{
// display data

}

However, I want the data to be displayed with 3 columns and with as many rows as necessary.

Eg: If there are 3 rows in the query, the results will be displayed in an html table (1x3)

If there are 6 rows in the query, the results will be displayed in an html table (2x3)

If there are 8 rows in the query, the results will be displayed in an html table (3x3) with the last row and last column being empty.

How do I do this? Thanks in advance for your help.

Roger_Ramjet

Count each query row and start a new <tr> after every third one.

thekidscareya

How would I do this? Can you explain in detail?

Thanks.

Roger_Ramjet

You have not even tried - that's why you've got no answers.

// set up column count
$cols = 3;

// set up counter
$i = 0;

// start table
echo '<table>';

while($row = mysql_fetch_array($query)) {

// if counter is zero start nerw table row
if ($i == 0 ) {
   echo '<tr>';
}

// display entry in table cell
echo '<td>' . $row['data'] . '</td>';

// count it
$i++;

// if count equals col count then end table row and reset counter
if ($i == $cols) {
   echo '</tr>';
   $i = 0;
}

}

// edn table
echo '</table>';

And if there are typos or minor logic errors then it is up to you to fix them - I won't.