you don't need to, but if you really want to ...
echo "<table border=\"0\">\n";
echo "<tr>\n";
$photocount = 0;
while($row = mysql_fetch_array($result))
{ $smallpic = $row['smallpic'];
echo "<td>$smallpic</td>\n";
if (($photocount % 3) == 2)
{ echo "</tr>\n<tr>\n";
}
$photocount++;
}
// this should add empty cells until the row is complete
while ($photocount % 3)
{ echo("<td></td>");
$photocount++;
}
echo "</tr>\n";
echo "</table>";
Tim Ward
> -----Original Message-----
> From: James, Yz [mailto:[EMAIL PROTECTED]]
> Sent: 27 February 2001 19:18
> To: [EMAIL PROTECTED]
> Subject: while loop and modulus?
>
>
> OK, using this code:
>
> <?
>
> echo "<table border=\"0\">\n";
> echo "<tr>\n";
>
> $photocount = 0;
>
> while($row = mysql_fetch_array($result)) {
> $smallpic = $row['smallpic'];
>
> echo "<td>$smallpic</td>\n";
>
> if (($photocount % 3) == 2) {
> echo "</tr>\n<tr>\n";
> }
> $photocount++;
>
> }
>
> echo "</tr>\n";
> echo "</table>";
>
> ?>
>
> And 8 photos in the table, I'm getting this output:
>
> <table border="0">
> <tr>
> <td>sm982438092.gif</td>
> <td>sm982437452.gif</td>
> <td>sm982439016.gif</td>
> </tr>
> <tr>
> <td>sm982529915.gif</td>
> <td>sm983222652.gif</td>
> <td>sm983222686.gif</td>
> </tr>
> <tr>
> <td>sm983222868.gif</td>
> <td>sm983222919.gif</td>
> </tr>
> </table>
>
> Great, except it's missing an end cell, and after a few hours
> fiddling about
> with code last night, I still didn't get any further in
> working out how I
> was going to echo a table cell even if data's missing. So,
> any help would
> be appreciated.
>
> Apologies for what're probably "easy" questions. I slog away
> at work all
> day, come back hoping to get something productive done on
> this, and the
> ol'brain won't take it. Frustrating, to say the least.
>
> James.
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]