MYSQLI_NUM does't work

[CompleteNewbie]

I'm trying to recreate the code from PHP, mysql, javascript, CSS and HTML from O'reily, but i can't make it work

 

Here's the code I added:

       

        $query = "select * from classics";
        $result = $connection->query($query);
        if (!$result) die ("Database access failed: " . $connection->error);
        $rows = $result->num_rows;
        for ($j=0; $j < $rows; ++$j)
        {
            $result->data_seek($j);
            $row = $result->fetch_array(MYSQLI_NUM);
        echo <<<_END
        <pre>
        Author        $rows[0]
        Title            $rows[1]
        Category    $rows[2]
        Year            $rows[3]
        ISBN           $rows[4]
        </pre>    
        _END;
        }
 

Here's the error i receive:

Notice: Trying to access array offset on value of type int in /var/www/html/test/mysqlitest.php on line 53

I didn't put all the code because everything else works well, i can connect to mysql and add stuff, but i can retrieve stuff using fetch_array['author'] but fetch_array(MYSQLI_NUM) doesn't work.

I've tried things from the web but I've only been doing php for a week so my knowledge is quite limited.

Thank you for your time.

[Barand]

forget the for() loop.

while ($row = $result->fetch_row() ) {
    echo $row[0];
    . . .
}

[CompleteNewbie]

i just found the problem 😅

while checking your proposition i realised i wrote $rows with an 's'...

Now it works