join, left or right... :S
Am trying to get a join in a recordset so that I am able to shwo the contents of the main table whilst also being able to show 1 column from 2 other tables.
The RS I have (and it isnt working) is
$FeaturedProductPanel = new WA_MySQLi_RS("FeaturedProductPanel",$DBConnection,1);
$FeaturedProductPanel->setQuery("SELECT products.*, productmanufacturers.*, productcategories.* FROM products RIGHT OUTER JOIN productmanufacturers ON products.ProductManufacturerID = productmanufacturers.ManufacturerName RIGHT OUTER JOIN productcategories ON products.ProductCategoryID = productcategories.CategoryName WHERE products.ProductLive = 1 ORDER BY Rand()");
What it is supposed to be doing is showing the product from the products table and then the CategoryName from the productcategories table and ManufacturerName from the productmanufacturers table that is relevant to the product itself...
Not sure where or what I have done wrong.