OK, have done that (and added products.ProductLive = 1 and getting a sql syntax error
Notice: Undefined index: perm in /home/motle7bk/public_html/clients/equicraft/shop-product-details_s.php on line 97
which references the variable line
<?php
$Categories = new WA_MySQLi_RS("Categories",$DBConnection,0);
$Categories->setQuery("SELECT productcategories.*, productcategories_2.CatPermalink AS parentpermalink FROM productcategories INNER JOIN productcategories AS productcategories_2 ON productcategories_2.CategoryID = productcategories.CategoryParentID WHERE products.ProductLive = 1 AND products.ProdPermalink = ? ORDER BY productcategories.CategoryOrder ASC");
$Categories->bindParam("s", "".$_GET["perm"] ."", "-1"); //permparam
$Categories->execute();
?>