[SOLVED] Joining tables gives errors

[LE224]

Hi, 

 

I already have a working and tested SQL statement below.

 

SELECT COUNT(DISTINCT 'ps_cart_product.id_product')

FROM 'ps_orders' INNER JOIN 'ps_cart_product'

ON 'ps_orders.id_cart'='ps_cart_product.id_cart'

WHERE 'ps_orders.id_customer' = 1;

 

Thanks, 

 

LE224

 

 

 

[sOLVED]

public static function getUniqueCustomerNbOrders($id_customer)

{

$sql = 'SELECT COUNT(DISTINCT c.`id_product`) AS nb

FROM `'._DB_PREFIX_.'orders` o

INNER JOIN `'._DB_PREFIX_.'cart_product` c ON (o.`id_cart`=c.`id_cart`)

WHERE o.`id_customer` = '.(int)$id_customer;

 

$result = Db::getInstance(_PS_USE_SQL_SLAVE_)->getRow($sql);

 

return isset($result['nb']) ? $result['nb'] : 0;

}

 

 

 

 

 

 

Edited November 17, 2015 by LE224 (see edit history)