Problem to list database data

Question

I’m having trouble storing the values of ORDER BY in php, I would like to store them in an array and show it on another page.

Database file with function:

    function buscar_rank($conexao) {
    $sqlBusca = 'SELECT * FROM usuario ORBER BY pontos;';
    $resultado = mysqli_query($conexao, $sqlBusca);

    $usuarios = array();

    while ($rank = mysqli_fetch_assoc($resultado)) {
        $usuarios[] = $rank;
    }

    return $usuarios;
}

file where you would like to store the results

<table>
   <tr>
       <?php $lista_rank = buscar_rank($conexao); 

       foreach($lista_rank as $rank) :
       ?>
       <td><?php echo $rank['nome']; ?></td>
       <td><?php echo $rank['pontos']; ?></td>
   </tr>
   <?php endforeach; ?>

Answer 1

The ORDER this spelled wrong, change to:

$sqlBusca = 'SELECT * FROM usuario ORDER BY pontos;';

You can also improve your function by changing to:

function buscar_rank($conexao) {
    $sqlBusca = 'SELECT * FROM usuario ORDER BY pontos;';
    $resultado = mysqli_query($conexao, $sqlBusca);

    return mysqli_fetch_all($resultado, MYSQLI_ASSOC);
}

The function mysqli_fetch_all already returns all lines in format array associative.