SELECT DISTINCT m.cUsername, count(*) as count_result
FROM membership m
LEFT JOIN trade_leads t ON m.cUsername=t.cUsername
LEFT JOIN product_msg p ON p.username=m.cUsername
LEFT JOIN companies c ON c.company_zcyh=m.cUsername
FROM membership m
LEFT JOIN trade_leads t ON m.cUsername=t.cUsername
LEFT JOIN product_msg p ON p.username=m.cUsername
LEFT JOIN companies c ON c.company_zcyh=m.cUsername
FROM membership m
LEFT JOIN trade_leads t ON m.cUsername=t.cUsername
LEFT JOIN product_msg p ON p.username=m.cUsername
LEFT JOIN companies c ON c.company_zcyh=m.cUsername";
$res = mysql_query($slq);$count_result = @mysql_num_rows($res);
$sql="SELECT DISTINCT m.cUsername
FROM membership m
LEFT JOIN trade_leads t ON m.cUsername=t.cUsername
LEFT JOIN product_msg p ON p.username=m.cUsername
LEFT JOIN companies c ON c.company_zcyh=m.cUsername";
$res = mysql_query($sql) or die('Query error');$count_result = mysql_num_rows($res) or die('Error fetch row');