警告：mysqli_retch_array（）要求参数1为mysqli_result，第41行的c：\ wamp \ www \ test \ shout.php中给出布尔值[复制]

Question

This question already has an answer here:

• mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result 32 answers

I'm trying to query my server for a message board and keep getting the above error. What am I doing wrong?

    //insert new message in db
    if(mysqli_query($sql_con,"INSERT INTO shout_box(user, message, ip_address) value('$username','$message','$user_ip')"))
    {
        $msg_time = date('h:i A M d',time()); // current time
        echo '<div class="shout_msg"><time>'.$msg_time.'</time><span class="username">'.$username.'</span><span class="message">'.$message.'</span></div>';
    }

    // delete all records except last 10, if you don't want to grow your db size!
    mysqli_query($sql_con,"DELETE FROM shout_box WHERE id NOT IN (SELECT * FROM (SELECT id FROM shout_box ORDER BY id DESC LIMIT 0, 10) as sb)");
}
elseif($_POST["fetch"]==1)
{
    $results = mysqli_query($sql_con,"SELECT user, message FROM (select * FROM shout_box ORDER BY id DESC LIMIT 10) shout_box ORDER BY shout_box.id ASC");
    while($row = mysqli_fetch_array($results))
    {
        $msg_time = date('h:i A M d',strtotime($row["date_time"])); //message posted time
        echo '<div class="shout_msg"><time>'.$msg_time.'</time><span class="username">'.$row["user"].'</span> <span class="message">'.$row["message"].'</span></div>';
    }
}

</div>

Answer 1

something is wrong here in SQL code because $results value is boolean false

 $results = mysqli_query($sql_con,"SELECT user, message FROM (select * FROM shout_box ORDER BY id DESC LIMIT 10) shout_box ORDER BY shout_box.id ASC");
    while($row = mysqli_fetch_array($results))
    {

print MySQL Error , right after this syntax and see whats happened

var_dump(mysqli_error($sql_con));