mysql php - while loops
| From: | Craig Westerman | Date: | Wed, 27 Feb 2002 00:43:25 +0000 |
| Subject: | mysql php - while loops | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-86346@lists.php.net to get a copy of this message | ||
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 ><>
westerman@chanuteks.com