jion help

[raptor30506090]

Im making a shopping cart

 

so my question is

 

$query = mysql_query("SELECT * FROM colour WHERE colour_id=".$colourID);
$query = mysql_query("SELECT * FROM products WHERE id=".$id);

can i make a jion so i select the product and then make a join to SELECT  the colour

[raptor30506090]

Im making a shopping cart

 

where is this going wrong?

 

$query = mysql_query("SELECT products.title, colour.colour FROM products INNER JOIN colour ON products.colour_ref=colour.".$colour);