This is outside the scope but: How do you join two tables where the Title comes from one table with the Categories, and the other has the rows of info that pertain to that title/Category, but I only want to display the ones where in a column named 'Condition' the field has the word 'Used'.
I tried $WADAecart_cat->setQuery("SELECT * FROM ecart_category, eCart_products JOIN ecart_category.ecart_cat_id ON eCart_products WHERE eCart_products.Condition = 'Used'");
I have the following fields but the problem is that it also displays the Tiles (and Photos) from the ecart_category table even when there isn't any 'Used' rows on the other 'eCart_products table.
You can see what I get here: https://www.converteraccessory.com/eCart/indexx2.php - So there's really like 3 Categories only that should show up since those have corresponding data from the other table.
My scripts are:
