sorry, am still getting an unknown column error
rs has been updated to
<?php
$Categories = new WA_MySQLi_RS("Categories",$DBConnection,0);
$Categories->setQuery("SELECT productcategories.CategoryName, productcategories.CatPermalink, productcategories_2.CategoryName AS parentcategoryname, productcategories_2.CatPermalink AS parentpermalink, products.*, productmanufacturers.ManufacturerName, options.* FROM productcategories LEFT OUTER JOIN productcategories AS productcategories_2 ON productcategories.CategoryParentID = productcategories_2.CategoryID LEFT OUTER JOIN products ON productcategories.CategoryID = products.ProductCategoryID LEFT OUTER JOIN productmanufacturers ON products.ProductManufacturerID = productmanufacturers.ManufacturerID LEFT OUTER JOIN optiongroups ON products.ProductID = options.OptionProductID LEFT OUTER JOIN options ON options.OptionGroupID = optiongroups.OptionGroupID WHERE productcategories.Live = 1 AND productcategories.CatPermalink = ? AND products.ProductLive = 1 ORDER BY productcategories.CategoryOrder ASC");
$Categories->bindParam("s", "".$_GET["perm"] ."", "-1"); //WAQB_Param1
$Categories->execute();
?>