Images arrangement

[dstonek]

I don´t know about PHP programming.
I am working with Dreamweaver MX to rebuild my old static site and change it to dynamic. I am working fine on it.
Browsing my site, when someone gets a dynamic group of images from MySQL tables I want to output them in a table (or whatever) of 5 columns instead of a single column obtained from a dynamic table.
Thanks in advance for any idea

[sarahk]

you code will be looping through the array of images returned and creating some html like

echo "<tr><td><img src='" . $record['imageName']. "'></td></tr>";

and what you need to do is put a counter in there which counts up to 5.

so you add

$cnter = 0;
while (more record stuff)
{
  if ($cnter == 0) echo "<tr>";
  //standard stuff
  echo "<td><img src='" . $record['imageName']. "'></td>";
  if ($cnter == 4) 
  {
     echo "</tr>";
     $cnter =  0;
  }
  else $cnter++;
}

this way you are still putting the info into the table cells but you're not starting and stopping the table rows until you are ready.

[dstonek]

Thank you for your quick answer.

Here is the code DWMX generates (I have cleaning "show ifs" and another adds)

<table>
<?php do { ?>
<tr>
<td><img src="<?php echo $row_idioma_es['fotow']; ?"></td>
</tr>
<?php } while ($row_idioma_es = mysql_fetch_assoc($idioma_es)); ?>
</table>

Then, studying your code I made some change that worked.

<table>
<?php do { echo "

<tr>
<td><img src='" . $row_idioma_es['fotow']."'></td>
</tr>";
} while ($row_idioma_es = mysql_fetch_assoc($idioma_es)); ?>
</table>

Finally I substituted the echo line but it didn´t work.
Please tell me what´s wrong. Thank you very much.

<table>
<?php do {
$cnter = 0;
while (more record stuff)
{
if ($cnter == 0) echo "<tr>";
//standard stuff
echo "<td><img src='" . $row_idioma_es['fotow']. "'></td>";
if ($cnter == 4)
{
echo "</tr>";
$cnter = 0;
}
else $cnter++;
}
} while ($row_idioma_es = mysql_fetch_assoc($idioma_es)); ?>
</table>

[dstonek]

I fixed the code.

<table
<?php
$cnter = 0;
do {
if ($cnter == 0) echo "<tr>";
//standard stuff
echo "<td><img src='" . $row_idioma_es['fotow']. "'></td>";
if ($cnter == 4)
{
echo "</tr>";
$cnter = 0;
}
else $cnter++;

} while ($row_idioma_es = mysql_fetch_assoc($idioma_es)); ?>
</table>