PDO NOT Showing Results

Question

this is my first Q.

I cant show the RESULT from $row['id'] ['name'] ['level'] IT only shows ID: NAME: LEVEL:

But the results doest appear

Ive tryed adding PDO::FETCH_ASSOC to the FETCH() but it says 1 parameter given expected 0

require_once 'connection.php';
$query = "SELECT * FROM members";
$stmt = $cnx->prepare($query);
$stmt->execute();

while($row = $stmt->fetch()) {
echo "Id: " . $row['id'] . "<br>";
echo "Name: " . $row['name'] . "<br>";
echo "Level: " . $row['level'] . "<hr>";
}

Answer 1

As you're using mysqli api, then it's a bit complicated to use fetch:

$stmt = $cnx->prepare($query);
$stmt->execute();

// first you need to bind result to variables:
$stmt->bind_result($id, $name, $level)
// also make sure that you bind the SAME number 
// of variables as number of fields selected in a query

while($stmt->fetch()) {
    echo "Id: " . $id . "<br>";
    echo "Name: " . $name . "<br>";
    echo "Level: " . $level . "<hr>";
}