I want to generate a list in pdf of the passengers on a bus ride.

My problem is, that in every second cell on the right side, there is the same person from the first cell in every row.

And i want to order them with “ut_utasok_ules_pozicio” column. This means the seat number on the bus.

My code is:

`$html .= ”;

    while($aa = mysqli_fetch_assoc($adat))
    {
        $html .= '<tr>
                    <td>'.$aa['ut_utasok_ules_pozicio'] . '. ' . $aa['utas_nev'] . '</td>
                    <td>'.$aa['ut_utasok_ules_pozicio'] . '. ' . $aa['utas_nev'] . '</td>
                 </tr>';
    }
    
    $html .= '</table>';`

I tried modify my sql query, but i think the problem isnt there.