The MySQL querie
SELECT * FROM ecart_category
INNER JOIN eCart_products ON ecart_category.ecart_cat_id = eCart_products AND eCart_products.Condition = 'Used'
didn't work
I now have
$Recordset1 = new WA_MySQLi_RS("Recordset1",$convacc_cx,0);
$Recordset1->setQuery("SELECT * FROM ecart_category INNER JOIN eCart_products ON ecart_category.ecart_cat_id = eCart_products.Cat_ID WHERE ecart_cat_id = ? AND eCart_products.Cat_ID = ecart_category.ecart_cat_id AND eCart_products.Condition = 'Used'");
$Recordset1->bindParam("i", "".($WADAecart_cat->getColumnVal("ecart_cat_id")) ."", "-1"); //tipcat_idparam
$Recordset1->execute();
But I still get the headers (titles and pictures) from the 'Categories' table. Even when there are no records of products 'Used'.
Attached is the file.


