Warning: mysql_fetch_array() expects parameter 1 to be resource

[Anwar11]

got error in this line :/ 
 

$sql = "SELECT * FROM product-categories";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)) <-- ( error in this line ) :/
  {
  echo "<tr><td><font color=blue>";
  echo "<a href=Items.php?id=".$row['id'].">".$row['id'] . " " . $row['name']. "</a>";
  echo "</td></tr>";
  
  }

please help

[QuickOldCar]

Use backticks to escape that dash

 

 

$sql = "SELECT * FROM `product-categories`";

[mike12255]

The above solution will work. It is best practice to use underscores ( _ ) rather then dashes for mysqli table names