PHP警告期望参数1是资源，给定对象

Question

I want to retrieve all data from a table, so I use this code

<?php
    include("config.php");
    $sql = "SELECT * FROM ".$USERS;
    $sql_result = mysqli_query($connection, $sql);
    if ($sql_result) {
      while ($result = mysql_fetch_assoc($sql_result)) {
         echo $result;
       }
    } 
    else {
       die ('Could not execute SQL query '.$sql);
    }
?>

but got this warning:

 Warning: mysql_fetch_assoc() expects parameter 1 to be resource,
 object given in C:\xampp\htdocs
ewSDP\phpscript\users.php on line 6

How can I fix it?

Answer 1

Change: mysql_fetch_assoc to mysqli_fetch_assoc