too long

Question

I have the following code:

$result=$db->query("SELECT * FROM gwub WHERE gwubStatus > 0") or die(mysqli_error($db));

if($result->num_rows>0) 
{
    while($row=mysqli_fetch_assoc($result)) {   

The query is running and doing what it requires on the database but I am still getting the following warning:

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, string given

I am getting no mysqli errors and if i run command direct on database it works fine. There is only one result if that makes any difference?

Answer 1

I'll bet anything you have an assignment to $result inside your loop, e.g. something like:

while ($row = mysqli_fetch_assoc($result)) {
    $result = $row['some_column'];
}

After that assignment, $result no longer contains the result of the query, it contains that column, which is a string. The next iteration of the loop tries to use that string when it calls mysqli_fetch_assoc($result), and this fails.

Solution: use a different variable inside the loop.