Auto increment variable in while loop

Question

I have a variable that is a string with divs in html.

I'm trying to include a number in it that starts at one and auto increments so that each div is numbered in ascending order.

This is my while:

while ($row9 = mysqli_fetch_array($query, MYSQLI_ASSOC)) {
$catname9 = $row9["catname"];
$statusid9 = $row9["id"];
$i = 1;

This is my string that I echo repeatedly until it reaches the end of my called SQL table:

$list9 .= '<div id="each9" style="margin-top:3px" onclick="moveTo(\'.main\', '.$i.');"></div>

Then I echo:

<?php echo $list9; ?>

So how do I make the first one 1 then the second repeat 2 and the third repeat 3?

Answer 1

Set up your while loop like so:

$i = 1;
while ($row9 = mysqli_fetch_array($query, MYSQLI_ASSOC)) {

    // looped logic here

    $i++;
}

The important thing here is to initialize the counter before the loop, and increment it on each iteration.

You can also increment it by other amounts if you want. Just replace $i++ with $i += 2;