php join.....question....

[dpabla]

hey whats up everyone...happy new years..

Question: A user clicks on a particular item on the webpage named Apples which ID = 2- the ID has been passed onto the next page. The newpage.php?id=2 should THAN display the Product name on the page...based on the the logic that the _Get variable would be set to "2" and a JOIN statement would be "ok we got a number 2 from the subcategory table, lets get that same number 2 and look up the product name which is Apple and output the name to the screen. My table is structured below....

Table named Products                       

subcategory_id          Product Name
---------------          --------------
2                                  Apple

Table #2 named: Subcategory
subcategory_id 
---------------
2                             

My code that I am stumped on:
[code]<?php

$result = mysql_query
("select subcategory_id, subcategory_name from products,subcategory
WHERE products.subcategory_id=subcategory.subcategory_id
subcategory_id= {$_GET['sub_id']}");
[/code]

Thanks so much for your help...the part I am stuck on is this: subcategory_id= {$_GET['sub_id']}"    <--------- thats my logical reasoning that the Select query needs to "GET" the variable "2" so that the subcategory ID's are being matched from both tables to output "APPLES"

[Eugene]

SELECT products.subcatergory_id, products.subcategory_name FROM products
JOIN subcategory ON products.subcategory_id = subcategory.subcategory_id
WHERE products.subdcategory_id = '{$_GET['sub_id']}'

Hope that helps.

[kateland]

I ran into that earlier...and you know what I did? Since I was doing everything GET anyway, and the SQL had already been done, I just passed the "product name" over along with the ID :)

[dpabla]

Thanks for your help....