How to show the pics ?

[cliffcc]

How can i show the pics in this way?

---------------------------------------

Pic 1 Pic 2 Pic 3 Pic 4 Pic 5 |
Pic 6 Pic 7 Pic 8 Pic 9 Pic 10 |
Pic 11 Pic 12 Pic 13 Pic 14 Pic 15 |
|
|
------------------------------ ------ |



But below code only show:

---------------------------------------

Pic 1 |
Pic 2 |
Pic 3 |
Pic 4 |
Pic 5 |
Pic 6 |
Pic 7 |
Pic 8 |
Pic 9 |
Pic 10 |
------------------------------ ------ |

Code: Select all

<?php
       
         $album = mysql_query("SELECT * FROM albums WHERE id='$id'");

         echo "<table width='50%'>";

         while ($row = mysql_fetch_assoc($album))

         {
          echo "
          <tr>
            <td>         
            <img src='".$row['pic']."' width='100' height='100' border='0'>     
            </td>       
           </tr>
         ";
         }
         echo "<table>";


?>


[Lecisco]

Your code puts out one row per picture (each row is surrounded by <tr>...</tr>). To get 5 per row you would need code like this:

Code: Select all

echo "<table width='50%'>";
$count = 0;
while ($row = mysql_fetch_assoc($album))
{
    if ($count % 5 == 0) {    // every 5 entries, put start a new row
        if ($count != 0)
            echo "</tr>";  // end the previous row
        echo "<tr>";  // start a new row
    }
    echo "
            <td>         
            <img src='".$row['pic']."' width='100' height='100' border='0'>     
            </td>";
    $count ++;  // add one to the count
}  // end while
if ($count > 0) echo "</tr>";  // end the row that was in progress
echo "</table>"; // end table