List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 27 2002 2:33am
Subject:Re: mysql php - while loops
View as plain text  
At 18:42 -0600 2/26/02, Craig Westerman wrote:
>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?

That's a good question, given that the query doesn't retrieve any images,
nor is it evident where else they might come from. :-)

But it sounds like you're talking about three loops, not one.

>
>Thanks
>
>Craig ><>
>westerman@stripped

Thread
mysql php - while loopsCraig Westerman27 Feb
  • Re: mysql php - while loopsPaul DuBois27 Feb
    • Re: mysql php - while loopsSommai Fongnamthip27 Feb
  • Re: mysql php - while loopsDL Neil27 Feb