Thursday, November 14, 2019

mysqli - PHP : Fatal error: Call to a member function fetch_assoc() on boolean

I have this code :



$sql = "SELECT * FROM trading 
WHERE order_status <> 'DELETE'
ORDER BY date DESC
LIMIT 2";
$result = $conn->query($sql);

while($row = $result->fetch_assoc()) { << LINE 96


if ($row["type"] == 'BUY') {
---- CODE CUT HERE ----


and it gives me this error message :



Fatal error: Call to a member function fetch_assoc() on boolean in /**/**.php on line 96



why this line 96 :



while($row = $result->fetch_assoc()) {


produce that error message?

No comments:

Post a Comment

hard drive - Leaving bad sectors in unformatted partition?

Laptop was acting really weird, and copy and seek times were really slow, so I decided to scan the hard drive surface. I have a couple hundr...