SIMPLE CODE - CANT SEE PROBLEM

[Peterod]

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\parkhall\quantities.php on line 21

 

This is the error message.

 

This is the code.  simple array query to display contents of table and I cant see where i have made the mistake.  hopefully someone can help.

 

<?php 


mysql_connect ("localhost", "******", "*****") or die ('I cannot connect to the database becuase: ' . mysql_error());

mysql_select_db ("matquant");


$query = mysql_query("SELECT * FROM quantities");




while ($row = mysql_fetch_array($query)) {  //line referred to in error message
echo "<br /> ID: "   .$row ['id'].
	 " material : "  .$row ['material'].
	 "quantity:"     .$row['quantity']. "<br />";}

?>

 

 

Please point out the probably glaring error.  I'm relatively new to this and I am really not finding php easy to learn.

 

[PFMaBiSmAd]

The error message means that your query failed due to an error.

 

Echo mysql_error(); on the next line after the line with your mysql_query() statement to find out why the query failed.

[Peterod]

didnt think of that.  thanks a bunch.  Solved