Because it also includes an array filled with columns’s positions (i.e: 0, 1, 2, 3 and id, username, password, email). Both id
and 0
hold the same data.
If you only want the string indexes, you can use mysqli_fetch_assoc
(http://php.net/mysqli_fetch_assoc)
0
solved Why does mysqli_fetch_array() return array double the size? [closed]