Displaying Category Name

I got a Products table where all general information is stored.

& productcategories table has all categories.

In Products table, each product store CatID. Now if i m on a product page & want to display CatName from productcategories table linking wit CatID how it do it?

Products table ProductCatID


DB screenshots attached.

use a join query to join the products.ProductCatID column on the product categories.CategoryID column.

see this page at w3schools for more details on sql joins:
http://www.w3schools.com/sql/sql_join.asp

well i had worked on the same.

I m adding this on my product-detail.php page now.

Already there is an existing product RS so not sure how well to edit them & view the category name.

I created a new RS which had got these:
SELECT Products.ProductID, productcategories.CategoryName, Products.ProductCatID
FROM Products
INNER JOIN productcategories
ON Products.ProductCatID=productcategories.CategoryID

Result seems fine, all results are shown but how do we include param variable into it to show particular product result (category name)?

All files attached also screenshot of NewRS & Existing RS for displaying product details.

I m not very sure if we need to modify existing RS or create RS for displaying category name.

Regards

I made a new RS ie:

SELECT Products.ProductID, productcategories.CategoryName, Products.ProductCatID
FROM Products INNER JOIN productcategories ON Products.ProductCatID=productcategories.CategoryID
WHERE Products.ProductID=colname1

colname1 type 'int' default value as '-1' and run-time value as : '$_GET['ProductID']

But no results found.

well i found my answer here:

http://www.webassist.com/forums/posts.php?id=8240

Thanks anyways :)

But got a solve doubt & stuck on it.

I used to it to display product category name on product detail page. Now when i use the same on other page ie. all products page where all products are viewed there it doesn't show cat name. Only last cat name is shown from database.

Tables are:
Products(all products are here) & productcategories (category names are here)

Have attached two files. product-detail is particular product page & other page is all products page where i have used repeat region to show all products which within has categoryname in it. But as said doesnt show right category name
Help needed.
Regards



Regards

your catname recordset needs to be a vested recordset, nested in the product repeat region.

see this tutorial:
http://www.webassist.com/tutorials/Display-nested-recordsets