Showing data from a database problem

[adiwood]

I want my products frok the database to be displayed. Im jus tryin to get them displayed at present, what is wrong with this? I have got the connection and stuff soted and it is working but the data isnt shown.

At present i get the error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

$query = 	"SELECT *
	 FROM Products
	 WHERE Productid = 3"

while ($row = mysql_fetch_array($result))
echo mysql_error();

{
$row["Productid"] . " " .
$row["ProductName"] . " " .
$row["ProductDescription"] . " " .
$row["ProductSpecification"] . " " .
$row["ProductPicture"] . " " .
$row["ProductPrice"] . " ";
}

[travelbuff]

I assume you have $result defined somewhere as follows :

$result = mysql_query($query) or die ('could not select products from the DB:' . mysql_error()); 

If not, the problem is that you are defining the query but not running it!

Also, I am assuming that there is a product in the DB w/a Productid of 3?