[RESOLVED] This should be simple but I have never done it

[jmartinez]

I have a MySQL database it has two fields ID and IMG. I am storing the img name and the id is a autoincrement. I want the values sent to a php page that loops and shows all the images. Ok I can do this, but the images just go straight down the page. How do you make the table loop the values across 4 columns and down X rows until all images are seen?

Database:

| ID | IMG |

PHP/HTML Table: (What I am wanting)

| IMG1 | IMG2 | IMG3 | IMG4 |

| IMG5 | IMG6 | IMG7 | IMG8 |

and so on until all images are shown. How is this done?

[Shrike]

Using a table layout, count to 4 before inserting a new <tr>.

  echo <table><tr>
while getDataFromDatabase
  ++$i
  echo <td><img stuff></td>
  if $i == 4
    echo </tr><tr>
    $i = 0
  endif
endwhile
echo </tr></table>

[ClarkF1]

This will display your images in a table of 4 columns wide by however many rows needed. If the number of images is not divisible by 4 it will print an empty cell instead.

Line breaks are added to make the generated html source code pretty

echo "<table><tr>\n";
$columns = 4;
$no_of_images = count($images); //image filenames are in array $images
$count = 0;

for ($i = 0; $i <= $no_of_images; $i++)
{
    if ($images[$p] != "") //checks to see if there is image information
    {
        echo "<td><img src=\"".$images[$i]."\"></td>\n";
        $count++;
        if ($count%$columns == "0")
        {
            echo "</tr><tr>\n";
        }
     } 
     else 
    {
         echo "<td></td>\n"; //prints empty cell if there is no image information
    }
}
echo "</tr></table>\n";

[jmartinez]

Thanks guys I appriciate it. I will toy with these and get one to work! =)