Help! Outputting database results into a table

[dai_hop]

Hi everyone,

Can anyone point me in the right direction please? 🙂

I want to output the results of a database query into a table - with a catch!

I'd like each result to have its own cell, and i'd like the table to be no more than 3 cells wide by total results / 3 rows high.

Here is my code, i'm struggling with this one!

[INDENT]echo '<table border="1">';

for ($cell_count=1; $cell_count <= 3; $cell_count++)
{
echo '<tr>';

for ($i=1; $i <= mysql_num_rows($result); $i++)
{
$row = mysql_fetch_array($result);
echo '<td>' . $row["file_location"] . '</td>';
}

echo '</tr>';
}

echo '</table>';[/INDENT][/COLOR]
I can't work out the logic of it!

Thanks for looking,

dai.hop

[Installer]

$num_columns = 3;
$num_rows = ceil(mysql_num_rows($result)) / 3;

echo '<table border="1">';
$col_ct = 1;
while ($row = mysql_fetch_array($result) {
    if ($col_ct == 1) {
        echo '<tr>';
    }
    echo '<td>' . $row['file_location'] . '</td>';
    if ($col_ct++ == $num_columns) {
        echo '</tr>';
        $col_ct = 1;
    }
}
if ($col_ct < $num_columns) {
    for ($i = $col_ct; $i <= $num_columns; $i++) {
        echo '<td>&nbsp;</td>';
    }
    echo '</tr>';
}
echo '</table>';

[dai_hop]

Hi Installer,

Thank you writing that code for me, and sorry for the late reply - I posted before I went on holiday!

Anyway, this code is giving me parser errors, more specifically:

"Parse error: parse error, unexpected '{' in C:\Program Files\xampp\xampp\htdocs\xampp\Outlook\gallery.php on line 265"

I have tried to debug the code, but you what it's like trying to debug someone elses code!

[dai_hop]

Hi Installer,

Scratch that last post, it was a missing bracket that was causing the trouble! All resoloved now!

Thank you very much for the code, it does exactly what I wanted it to do!

Cheers,

dai.hop