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
解决方案 »
- Zend Studio的一点小问题
- 小菜不知想请各位大师指路(PHP自动生成静态页)
- 急啊,小弟新手,没用过SOCKET编程,请高手指教,在线等!!!!!
- PHP异步执行问题
- 有谁在redhat9.0下使用默认安装的mysql编译PHP成功的?--with-mysql=的路径应该指定什么?
- 请问怎么更新BLOB字段?
- 在php中如何将数据库中的数据以.gz的压缩格式下载下来?
- 用PHP发邮件怎么不行?
- 关于163邮箱SMTP功能公司网络禁用、需要实现SMTP功能
- PHP如何将MYSQL中SELECT出来的结果存入到已有数组中?
- 我想在mysql中按一段中文首字拼音排序,可以做到么?
- php4中class的问题.help
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');