CategoryID

I am having trouble getting my actual CategoryID to show for my products on my detail page. I get the number to show from my products table, but not the actual Name from the productcategory table. For example, if a shirt is in the Men Hoodie Category, how do I get it to show on my product detail page?

you would need to edit the product recordset to use a join query to get the category name from the category table that relates to the product.

i see you have a column in your products table named CategoryID, so an example of the query would be:
SELECT products.*, categories.CategoryName
FROM products
INNER JOIN categories
ON products.CategoryID = category.CategoryID

NOTE: Don't edit the where clause, leave the where clause as is

for more detail son join queries, see this page:
sql_join.asp

I have tried this but I still get the number and not the Name. Here is the SQL statement I am using.

you have to replace the binding on the page that shows the category id with the binding for the category name.

Thanks that worked!

So when I do a product search in my product_search page, based on categories, I get the following error on my results page:

Unknown column 'CategoryName' in 'where clause'

you need to edit the recordset on the results page to use the same join query from before:
SELECT products.*, categories.CategoryName
FROM products
INNER JOIN categories
ON products.CategoryID = category.CategoryID

Ok so now everything looks normal. The products are not displaying when I search by category though.

please send a link where i can see the problem.

products_Search.php