Trouble with tables need help

[rico179]

I am brand new to PHP...

I have created two tables. One for products and the other for categories. I then created the appropriate pages to enter data into each of these tables.

I have been successful in figuring out the code needed to display the results from each of the tables. What I can't figure out is how to create a page that can associate the products to categories. In other words, I want my visitors to be able to click on the desired category and then see a list of products under the category name.

I'm sure the answer is very simple and would just appreciate someone getting me in the right direction. I really enjoy learning PHP.

[palpatine]

i assume you have some type of relationship set up between your 2 tables? If so, the query on your category display page should probably look something like this:

select name, blah, blah from product_table where category_id = '$cat_variable'

and then you should be able to handle displaying your data.

wherever you are building your link to this page it should probably look something like this

<a href="category_view.php?cat_variable=12">Category X</a>

hope this helps, and good luck.

[rico179]

thanks,

i just needed to be guided in the right direction.