After the loop has finished executing add another line
if ($i % $cols != $cols-1) { print "</tr>"; }
Otherwise once the loop has finished if not EXACLTY $i % $cols == $cols-1
then there would be no </tr> after the last row which could cause display
problems in the user agent (other than the fact that its putting out
incorrect html)
=S.
On Wed, 27 Feb 2002, Martin Towell wrote:
> with a bit of cheating... use a table...
> (nb: this code not tested, but logic has)
>
> <table>
> <?
> $results = mysql_query("SELECT ID, date, appleprice, orangeprice, pearprice
> FROM fruits");
> $i = 0; $cols = 4
> while ($data = mysql_fetch_array($results))
> {
> if ($i % $cols == 0) echo "<tr>"
> ?>
> <td><?=$data["date"]?> - <?=$data["appleprice"]?><br>
> <?=$data["orangeprice"]?> - <?=$data["pearprice"]?></td>
> <?
> if ($i % $cols == $cols-1) echo "</tr>";
> $i++;
> }
> ?>
> </table>
>
> -----Original Message-----
> From: Craig Westerman [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 27, 2002 11:43 AM
> To: php-general-list
> Subject: [PHP] mysql php - while loops
>
>
> The following lists 12 items from a fruits table.
>
> $results = mysql_query("SELECT ID, date, appleprice, orangeprice, pearprice
> FROM fruits");
> while ($data = mysql_fetch_array($results))
> {
> ?>
> <p><?=$data["date"]?> - <?=$data["appleprice"]?> -
> <?=$data["orangeprice"]?> - <?=$data["pearprice"]?></p>
> <?
> }
>
> How would I modify the loop to display 4 items then a row of fruit images
> then 4 more items then another row of different fruit images and then
> finally finish the loop displaying the final 4 items?
>
> Thanks
>
> Craig ><>
> [EMAIL PROTECTED]
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
