Getting rows from SQL DB with SQLI and printing their data

Question

EDIT: Ive adjusted my code

$rows = 0;          
$connection = mysqli_connect("a", "a", "a", "a");
$rows = mysqli_query($connection, "SELECT COUNT(*) FROM chat");

for($i = 0; $i < $rows; $i++){
    $result = mysqli_query($connection, "SELECT * FROM chat WHERE chat_index = 1"); 
    $row = mysqli_fetch_all($result, MYSQLI_ASSOC);             

    echo "<span>".$row['name']."</span>";
    echo "<img src='".$row['avatar']."'></img>";
    echo "<span>".$row['flair']."</span>";
    echo "<span>".$row['message']."</span>";
}

Yet nothing displays. https://CSGOVoid.net/chat

---

EDIT: What is the most efficient way of printing my data?

Should print (in order):

-Name

-Avatar

-Flair

-Message

---

I'm trying to go through every row and print the data in each column, I'm using the following:

$connection = mysqli_connect("domain", "username", "password", "mytable");
$rows = mysqli_query($connection, "SELECT COUNT(*) FROM chat");

echo $rows;

for($i = 0; $i < $rows; $i++){
    $steamid = mysqli_query($connection, "SELECT steamid FROM chat WHERE chat_index = ".$i);
    $name = mysqli_query($connection, "SELECT name FROM chat WHERE chat_index = ".$i);
    $flair = mysqli_query($connection, "SELECT flair FROM chat WHERE chat_index = ".$i);
    $avatar = mysqli_query($connection, "SELECT avatar FROM chat WHERE chat_index = ".$i);
    $message = mysqli_query($connection, "SELECT message FROM chat WHERE chat_index = ".$i);

    echo "<span>".$name."</span>";
    echo "<img src='".$avatar."'></img>";
    echo "<span>".$flair."</span>";
    echo "<span>".$message."</span>";
}

I'm receiving the following error:

Catchable fatal error: Object of class mysqli_result could not be converted to string

Answer 1

php documentation: http://php.net/manual/en/mysqli.query.php

Return Values: Returns FALSE on failure. For successful SELECT, SHOW, DESCRIBE or EXPLAIN queries mysqli_query() will return a mysqli_result object. For other successful queries mysqli_query() will return TRUE.

your previous code does not retrieve a string for $steamid, $name, $flair, etc, but actually receives objects, which then can use functions to obtain the values you are looking for :).

Let me know if that helped