mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given

[davids_media]

I have a problem at the moment. I want to create dynamic hyperlinks, so when new links are eventually added, they will automatically populate rather than create them one by one.

 

The problem I have is the displaying of them at the moment. Because I have gone down the procedural route, I have done my code like this;

 

<?php
require_once (MYSQL);

$query = "SELECT * FROM cat WHERE catID='{$_GET['catID']}' ORDER BY cat ASC";
$r = mysqli_query($dbc, $query);
while($row = mysqli_fetch_array($r, MYSQLI_ASSOC))
{
echo "<li>" . "<a href='cat.php?catID={$row['catID']}' title='{$row['cat']}'>" . $row['cat'] . "</a>" . "</li>";
}

?>

 

However I get the error message as displayed as my topic title. How do I resolve this please as I dont think I have much work to do, though its just a real struggle trying to resolve it.

[Jessica]

It means your query failed. You need to check if the result was false before trying to use it.

 

This needs to be a sticky topic, I see this same post every day.