Display Products within a category

i have a dynamic category page. page is attached.

i used .htaccess to change url link.

i want to display products in dynamic category page.

ei. if CategoryID=1 from productcategories then display products within the open category..

product-details.php & category-details.php are dynamic page.
From products page when i click on category name page link appears to be as : .../categories/category-name (this is exactly how i wanted)

Now currently on category-detail page i used following codes in RS:

SELECT *
FROM products
WHERE ProductCategoryID = colnamez

& colnamez as : $row_categories['CategoryID']

But this doesn't work. no products are displaying.

Regards

so the URL is passing the category name:

/categories/category-name

but in the recordset you are trying to use the Category ID:
WHERE ProductCategoryID = colnamez

and then you say:
& colnamez as : $row_categories['CategoryID']

meaning you are using the category ID returned by the recordset.

This is circular logic.

first off, what is the name of the URL variable that is created by your mid rewrite link. in other words, what is mod rewrite converting the URL to:
/categories/category-name

category-name should get converted to a URL variable, something like:
?CategoryName=<Name of category>

in your recordset, you would need to set the WHERE clause to filter the category name column on the URL variable.

In my productcategory table i have id, name, catlink.

reason i have catlink is for using it for customising category link.

so uses catlink.

Now from categories RS, can i get id of it & link it to products table for displaying filtered products with productcatid.

Regards


my .htaccess page:
RewriteEngine on

RewriteRule ^products/(.*)$ product-details.php?ProductLink=$1 [NC,L,QSA,T=application/x-httpd-php]
RewriteRule ^categories/(.*)$ category-details.php?catlink=$1 [NC,L,QSA,T=application/x-httpd-php]

so your path will use the catlike value, and your recordset will filter the catlike column on the catlike URL variable.

attached is my current category page. (dynamic)

unable to fetch product under same category.

category-details uses 'CategoryLink' from productcategories table.
this needs to be linked with 'ProductCategoryID' from products table with CategoryID from productcategories table.

SELECT products.*, productcategories.*
FROM products INNER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID
WHERE products.ProductCategoryID = colname1

colnam1 value: $row_categories['CategoryID']


I know this is stupid but i m not able to fix this.

I don't know how do we filter this type of situation.

your rewrite rule converts the passed category link to URL v variable named catlink:
RewriteRule ^categories/(.*)$ category-details.php?catlink=$1 [NC,L,QSA,T=application/x-httpd-php]


use the UIRL variable in your recordset:
$_GET['catlink']

also, it would seam to me that the link passed the catlike column from your table right? so you should be using the catlink column in the recordset.

yet not working.
productcategories table is attached.

& its CategoryLink*

Originally Said By: Jason Byrnes

  your rewrite rule converts the passed category link to URL v variable named catlink:
RewriteRule ^categories/(.*)$ category-details.php?catlink=$1 [NC,L,QSA,T=application/x-httpd-php]


use the UIRL variable in your recordset:
$_GET['catlink']

also, it would seam to me that the link passed the catlike column from your table right? so you should be using the catlink column in the recordset.  

suppose if i m at category page called: xyz

link would be .../categories/x-y-z ('x-y-z' is Categorylink)

now if i use, $_GET['Categorylink'] then its going to use x-y-z as CategoryID.
I want x-y-z's CategoryID to be used to match with product.ProductCategoryID

in the recordset, filter using the Categorylink column and the catlink URL variable.

if you are trying to get the related products, your recordset should use a join query.

see the following page:
http://www.w3schools.com/sql/sql_join.asp



Note, you say:
now if i use, $_GET['Categorylink']

the url variable that is created by your rewrite rule is name "catlink" not "Categorylink"

RewriteRule ^categories/(.*)$ category-details.php?catlink=$1 [NC,L,QSA,T=application/x-httpd-php]

sorry but then i changed so that its clear.

catlink is now CategoryLink.

in the recordset, filter using the Categorylink column and the catlink URL variable.


Now i m bit confused here.
I earlier got this sql_join as you mentioned above & used it to display category name by filter ie.:

SELECT products.ProductID, productcategories.CategoryName, products.ProductCategoryID
FROM products INNER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID
WHERE products.ProductID = colname1

colname1 value : $row_WADAproducts['ProductID']

Now if i use same logic on display products it doesn't seem to work.

I got this :

SELECT products.*, productcategories.*
FROM products INNER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryID
WHERE products.ProductCategoryID = colname1

Colname1 : $row_categories['CategoryID']