recorset broken
Hey Ray
Am not sure if this got 'broken' from the other aspects we did on Moonraker but this recordset is now not returning any results and it should be showing 5 items that are in the same category as the product page that it is on
<?php
$MayLike = new WA_MySQLi_RS("MayLike",$DBConnection,5);
$MayLike->setQuery("SELECT productcategories.CategoryName, productcategories.CatPermalink, productcategories_2.CategoryName AS parentcategoryname, productcategories_2.CatPermalink AS parentpermalink, products.*, productmanufacturers.ManufacturerName, productmanufacturers.ManufacturerImage, productmanufacturers.ManufacturerDescription, productmanufacturers.ManPermalink FROM productcategories INNER JOIN productcategories AS productcategories_2 ON productcategories.CategoryParentID = productcategories_2.CategoryID LEFT OUTER JOIN products ON productcategories.CategoryID = products.ProductCategoryID INNER JOIN productmanufacturers ON products.ProductManufacturerID = productmanufacturers.ManufacturerID WHERE productcategories.CategoryID = ? AND products.ProductLive = 1 AND products.ProductID <> ? ORDER BY Rand()");
$MayLike->bindParam("s", "".$Categories->GetColumnVal("CategoryID") ."", "-1"); //WAQB_Param1
$MayLike->bindParam("s", "".$Categories->GetColumnVal("ProductID") ."", "-1"); //WAQB_Param1
$MayLike->execute();
?>
