How to use total rows in mysql table for loop's counter in php?

Asked Apr 01 '20 at 08:30

Active Apr 01 '20 at 10:57

Viewed 14 times

I want to use my total rows in mysql tabel for loop's counter, so I need to count the rows in my table right?

This is my obviously wrong code:

  $result = mysqli_query($con,"SELECT * FROM pemain_winger");
    $rows = mysqli_num_rows($result);

    for($a=1;$a<=$rows;$a++) {
        echo ...
       }

Its always give Undefined offset: 3 error, pls help me :(

edited Apr 01 '20 at 10:57

Dharman

30,962
25
85
135

asked Apr 01 '20 at 08:30

Deadless Dead

from where you got `$nama` variable? As well use `while` loop to iterate – Alive to die - Anant Apr 01 '20 at 08:33
Whoops my bad... So I should use while instead for? – Deadless Dead Apr 01 '20 at 08:42
yes................ – Alive to die - Anant Apr 01 '20 at 08:48
https://stackoverflow.com/questions/1756743/how-to-loop-through-a-mysql-result-set – Alive to die - Anant Apr 01 '20 at 08:56

How to use total rows in mysql table for loop's counter in php?

0 Answers0