[Resolved] Count whiles

[areid]

How do I count how many whiles have been done. What I would like to do is, after every 3 whiles echo something. I hope that made sense.

Here is my code.
<?
$result=mysql_query("SELECT Item_Number, Title, SubID, Avail, Price, CatID FROM tblProducts WHERE CatID='$CatID';");
if ($row = mysql_fetch_array($result)) {
do{
echo "$row[1]";
} while($row = mysql_fetch_array($result));
}
?>

Thanks

Alex

[LordShryku]

You could set an internal counter...

$i = 1; # counter
while($row = mysql_fetch_array($result)) {
   echo $row[1];
   if($i % 3) {
      echo "something every third row";
   }
   $i++; # increment counter
}

Though, you could just do a for loop instead.

[areid]

Thank you for your reply....

but you know, I just can't get it to work. I am a little lost on where to up your suggestion in my code. What do I replace and where do I place it?

One way that I did it did this..

Adams GT Irons
something every third row
Odyssey DFX Putters
something every third row
Carnoustie Wedges
Cobra SS-i Irons
something every third row
Ping G2i Putters
something every third row

here is the code

$result=mysql_query("SELECT Item_Number, Title, SubID, Avail, Price, CatID FROM tblFeatured WHERE CatID='$CatID';");
if ($row = mysql_fetch_array($result)) {
$i = 1; # counter 
while($row = mysql_fetch_array($result)) { 
   echo "$row[1]<br>"; 
   if($i % 3) { 
      echo "something every third row<br>"; 
   } 
   $i++; # increment counter 
}

}

I've tried everything that I can think of
Thanks for all your help!

[LordShryku]

My bad. Change this:

#this line
if($i % 3) {
#to this
if(($i % 3) == 0) {

[tommynanda]

IGNORE... LordShryku already in action 😉

[areid]

EXALENT!!! It worked perfectly.

This is what I wanted.

TaylorMade R7 Driver
Adams GT Irons
Odyssey DFX Putters
something every third row
Carnoustie Wedges
Cobra SS-i Irons
Ping G2i Putters
something every third row

Thanks for you help! I appreciated it!