将变量赋值给数组值并填充<td>

Question

I have the following code inside a WHILE loop following a MySQL query:

$values=array(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30);

echo "<tr>
        <td class='results'>$values</td>
        <td class='results'>working query</td>
    </tr>"

I need the $values variable to populate and increase by 1 for each row obtained from the query.

Desired result:

1 | data
2 | data
3 | data

Answer 1

You didn't post the while loop, so I just assume how it looks like. You can just add a simple counter variable and increase for every row returned from DB:

$i = 1;
while ($row = mysqli_fetch_assoc($res)) {
    echo "<tr>
        <td class='results'>$i</td>
        <td class='results'>working query</td>
    </tr>";
    $i++;
}