无法回显SELECT COUNT的结果

Question

i am trying to echo the result of the SQL SELECT COUNT but it seems doesn't work for me, can anyone of you help me? The error show that

mysql_fetch_array expects parameter 1 to be resources, boolean given ....

This is my sql

 <?php
   $query = ("SELECT COUNT(*) AS total FROM `errors` WHERE `sta` = 0");
   $result = mysql_query($query);
   $count = mysql_fetch_array($result);
   echo $count['total'];
   ?>

Answer 1

Try to following code:

 $query = ($con, "SELECT COUNT(*) AS total FROM errors WHERE sta = 0");
 $count = mysqli_fetch_assoc($query);
 echo $count['total'];

Hope will help you