url path confusion

right... i can see what you have done but to say i understand it would be a lie :( sorry but its a lot confusing

now I have to get the target product detail page set up and not sure how to modify the RS / htaccess further and allow the product details to be shown

Also, as you will see on the sub cat pages, there is a navigation set in the right hand column which replicates all the sub cats, I need to also do this on the product results pages and the product results pages so that it shows the sub cat categories on all of them....

also, do i need the recordset 'pagecontents' that I had created prior to usin gthe 'categories' one we created the other day?

$PageContents = new WA_MySQLi_RS("PageContents",$DBConnection,1);
$PageContents->setQuery("SELECT productcategories.*, settings.CompanyName, settings.Town, settings.County, settings.PostCode FROM productcategories, settings WHERE CategoryID = ? OR CatPermalink = ? AND Live = 1");
$PageContents->bindParam("i", "".(isset($_GET['id'])?$_GET['id']:"")  ."", "-1"); //paramOffersID
$PageContents->bindParam("s", "".(isset($_GET['perm'])?$_GET['perm']:"")  ."", "-1"); //paramPermalink
$PageContents->execute();

or has it become redundant?