mysql querry error message

Hi

What does this error message mean
mysql_fetch_array() expects parameter 1 to be resource, boolean given

i googled any possible answers but cannot find a solution.

please help

D

paste the query code that generates the error... perhaps then we can help . . .

Your SQL query has failed and returned "false".

There is most probably a syntax error in your SQL statement.

Hi

This is the code that qives me an error
$query = "SELECT * FROM 'fixtures'";
$result = mysql_query($query) or die("Query failed: " .mysql_error());
echo '<table border="1"><th>Date</th><th>Fixtures</th><th>Venue</th>';
while ($row = mysql_fetch_array($result)) {
echo '<tr>
<td>'. $row['date'] .'</td>
<td><a href="fixtures_public.php? id='. $row['fixture_id'] .'">Gaza Club vs '. $row['opponents'] .'</a></td>
<td>'. $row['venue'] .'</td>
</tr>';
}
echo "</table>";

You don't need the single quotes around 'fixtures'.

Variables within single quotes are not interpreted.

yes the issue is those single quotes... leave them out or use the the little backslanted quotes to the right of your "1" key