Reading more than one cell from a mySQL table.

[HappyPandaFace]

I'm trying to read all the data in a table and I'm using the code:

$query = "select name, xpos, ypos from playervars";

$result = mysqli_query($cxn, $query)

or die("Could not execute query.");

$row = mysqli_fetch_assoc($result);

print_r ($row);

And all it returns is the first line of the table. I want to select it all. Is this possible?

[Barand]

while ($row = mysqli_fetch_assoc($result)) {
       print_r ($row);
}