Unsuccessfull attempts at trying to create a simple product list output

[Freedom-n-Democrazy]

I am wanting to create a basic product listing page for a product category called "Belts".

 

My latest attempt was this, but I got an error:

PHP Code:

$query = "select * from products";
$result = mysql_query($query);
while($row=mysql_fetch_assoc($result)) {
    print ".$row['name'] where category = 'Belts'.$row['colour'] where category = 'Belts'";
} 

 

PHP Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING

 

This is what my MySQL table looks like:

http://i54.tinypic.com/2j1si8w.png

 

I image what I am trying to do will print "Somename Black, ProductName2 Brown"?

 

I'm not really interested in styling at the moment, I just want to see the PHP-MySQL work at the most basic level.

 

I am unsure what the error cosde means. Can anyone see a fault in my code?

[MasterACE14]

<?php
$query = "SELECT * FROM `products` WHERE `category`='Belts'";
$result = mysql_query($query) or die(mysql_error()); // debugging purposes
while($row = mysql_fetch_assoc($result)) {
   print $row['name'] . ' - ' . $row['primarycolour'] . '<br />';
}
?>

[Freedom-n-Democrazy]

Hey Master,

 

Thanks for your help mate, it worked! Much appreciated!