RS wrangling
hi Ray
have a site that has a structure of
and am trying to modify a recordset (below) that uses a structure
to accommodate the shop > category > product structure.
<?php
$Categories = new WA_MySQLi_RS("Categories",$DBConnection,0);
$Categories->setQuery("SELECT productcategories.CategoryName, productcategories_2.CategoryName AS parentcategoryname, productcategories.CatPermalink, productcategories_2.CatPermalink AS parentpermalink, products.* FROM productcategories INNER JOIN productcategories AS productcategories_2 ON productcategories_2.CategoryID = productcategories.CategoryParentID LEFT OUTER JOIN products ON products.ProductCategoryID = productcategories.CategoryID WHERE productcategories.Live = 1 AND productcategories.CatPermalink = ? AND products.ProductLive = 1 ORDER BY products.ProductOrder ASC");
$Categories->bindParam("s", "".$_GET["perm"] ."", "-1"); //permparam
$Categories->execute();
?>
Have spent ages trying to pick apart what it needs to be but just keep getting confused.......page also attached
This is the rewrite that I am using:
RewriteRule ^shop/(.*)/(.*)/(.*)$ shop_product_details_s.php?perm=$3 [NC,L,QSA,T=application/x-httpd-php]
RewriteRule ^shop/(.*)/(.*)$ shop_product_results_s.php?perm=$2 [NC,L,QSA,T=application/x-httpd-php]
RewriteRule ^shop/(.*)$ shop_product_results_s.php?perm=$1 [NC,L,QSA,T=application/x-httpd-php]
I appreciate with that I will need to remove one of the rewrites as the new rs etc will only be 2 layers rather than the 3 that I am trying to modify.
thanks in advance
Jamie