while(mysql_fetch_array)...

rIkLuNd

I just have one little question:
I know how to do to print every row in a vertical order, but what if I want to have, for example, 4 images in a table row, each one in its own column, and when 4 images have been collected from the database and printed on the page, I want the script to add a new row, and so on. How should I do?!

If this wasn't good enough, here's just a little example to show what I mean:

<html>
<head>
<title>Test Page</title>
</head>

<body>
<table border="1">
<tr>

</tr>

</table>
</body>
<html>

Kerry_Kobashi

Something like this Ricklund...

Note:

Some of this is pseudo code.... this is just to give you an idea....

$itemsPerRow = 4;

// execute sql query getting records (in case its zero)
// -------------------------------------------------------------------
$numRecords = mysql_numrecords(blah blah);
if ($numRecords > 0)
{
      // begin table tag
      echo "<table>";       

// retrieve record one by one and force $itemsPerRow
// ------------------------------------------------------------------
$col = 1;
while ($result = mysql_fetch(blah))
{
    // begin row tag
    if (($col % $itemsPerRow) == 1)
        echo "<tr>";

    // output image column
    echo "<td>";
    echo "<img src=/"images/" . $result['filename'] . "/"";
    echo "</td>";

    // end row tag
    if (($col % $itemsPerRow) == 0)
        echo "</tr>";

    // increase column count
    $col++;
 }  // end while fetch

// fill last row with columns of spaces (to eliminate ugly look)
// ---------------------------------------------------------------------------
while (($col % $itemsPerRow) != 0)
{
    echo "<td>non-blank token space here - nbsp</td>"
    if (($col % $itemsPerRow) == 0)
          {
          echo "</tr>";
          break;
         }

    $col++;
} // end while fill

// end table tag
echo "</table>";
}

Kerry Kobashi
Kobashi Computing