Hm - bekomme immer noch die ID von table merchant:
PHP-Code:
$query = "SELECT products.id, products.ProductName, products.Price, products.Currency, products.ImageURL, products.Category, products.ProductDescription, products.merchantid, categories.id, categories.cat, merchant.id, merchant.logo FROM products
LEFT JOIN categories ON(categories.id = products.Category)
LEFT JOIN merchant ON(products.merchantid = merchant.id)
WHERE products.Category = '$cid' ORDER BY Price ASC $limstring ";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result))
{
echo $row[ 'id' ];