How to display the entire array loaded from MySQL?

Question

PHP

I have been suffering with one problem for a long time
. When I display an array loaded from MySQL, one of the elements is not displayed, I have to load it separately. And the reason is generally clear - there is no error in the code - the problem is in the imperfection of the code. Maybe someone will suggest a more interesting output method. How do I output:

while($row = mysql_fetch_array($result)){
//действия внутри цикла
};

Answer 1

Everyone does this:

while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
    printf("ID: %s  Имя: %s", $row[0], $row[1]);
}