table relationship trouble

cbesh2

🙁
I am trying to create a relationship between 3 tables (products, color and size). In my first script, all products in my database are displayed. The user then selects the product link they wish to view.

Below is the first script:

<?php
//DATABASE VARIABLES LIST
//prod_id = product ID number
//prod_name = product name

EDITTED FOR LENGTH - CONNECT TO DATABASE HERE

$query = "SELECT * FROM products";
$results = mysql_query($query)
or die(mysql_error());
?>
<HTML>
<HEAD>
<TITLE>Products Page</TITLE>
</HEAD>
<BODY>
<div align='center'>

Below are the list of products:
<br><br>
<table width='300'>
<tr>

<?php
// Show List of Products
while ($row = mysql_fetch_array($results)) {
extract ($row);
echo "<td>";
echo "<a href = 'getprod.php?prodid=" . $prod_id ."'>";
echo $prod_name;
echo "</td></a></tr>";
}
?>
</table>
</div>
</BODY>
</HTML>

continued...

cbesh2

The second script is suppose to display the results from the first script. However, I am having problems creating a relationship between the tables.

Below is my second script:

<?php
//VARIABLES USED IN TABLE "PRODUCTS"
//prod_id = product ID
//prod_name = product name
//color_id = ID reference for product color
//image_id = used to reference corresponding product image

//VARIABLES USED IN TABLE "COLORS"
//color_id = ID reference for product color
//color = name of color

//VARIABLES USED IN TABLE "SIZE"
//size_id = ID referencce for product size
//size = size of product

EDITTED FOR LENGTH - CONNECT TO D.B.

$prodid=$_REQUEST['prodid'];
query_Recordset1 = "SELECT color, size FROM colors, size WHERE products.prod_id='$prodid'";
$Recordset1 = mysql_query($query)
or die(mysql_error());
$row = mysql_fetch_array($results);
extract ($row);

echo $prod_name;
echo $color
echo $size;
?>

Anybody help?