PHP: for loop showing same result twice instead of the two distinct results?

Question

I have a SELECT query in MySQL, that I've tested in phpMyAdmin and it shows two records, where the same user (Number 1), has two roles (noAutorizado and admin):

Now, I've tried to show that in a list using a for loop, and it shows the first result twice instead the two results. So instead of showing noAutorizado and admin, it shows noAutorizado and noAutorizado.

What's wrong with the loop?

$conectar2 = mysqli_connect(HOST, USER, PASS, DATABASE);
$buscarRoles = "SELECT userID, nombreRol
          FROM rolesUsuarios
          WHERE userID='$uid'
          ";
$roles = mysqli_query($conectar2,$buscarRoles);     

    if($roles){
        $rol = mysqli_fetch_array($roles);
        $cantRegistros = mysqli_num_rows($roles);
        for ($i=0; $i < $cantRegistros; $i++) { 
            echo $rol['nombreRol'].'<br>';
        }
    } else ...

while($rol = mysqli_fetch_array($roles)) { echo $rol['nombreRol'].'<br>'; } — JYoThI
– JYoThI, Commented Jul 23, 2016 at 10:39

Professor Abronsius · Accepted Answer · 2016-07-23 10:39:40Z

3

I think you need to fetch the results in a loop

$conectar2 = mysqli_connect(HOST, USER, PASS, DATABASE);
$buscarRoles = "SELECT userID, nombreRol
          FROM rolesUsuarios
          WHERE userID='$uid'";
$roles = mysqli_query($conectar2,$buscarRoles);     

if($roles){
    while( $rows=mysqli_fetch_object($roles) ){
        echo $rows->nombreRol.'<br>';
    }   
}

answered Jul 23, 2016 at 10:39

Professor Abronsius

33.9k5 gold badges36 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

JYoThI · Accepted Answer · 2016-07-23 10:40:40Z

1

That's because the array represents a single row in the returned result set. You need to execute the mysqli_fetch_array function again to get the next record. Example:

 while($rol = mysqli_fetch_array($roles)) { echo $rol['nombreRol'].'<br>'; }

answered Jul 23, 2016 at 10:40

JYoThI

12.1k1 gold badge13 silver badges26 bronze badges

Collectives™ on Stack Overflow

PHP: for loop showing same result twice instead of the two distinct results?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related