我正在尝试获取确定的任务类型的数量,但它给了我错误:试图获取非对象的属性
$statement = $pdo->prepare("SELECT COUNT(DISTINCT Company_Name)
FROM salesplus WHERE `Task_Type` = 'Form Sent'
AND `Consultant_name` = 'Name Surname'");
$statement->execute();
$result=$statement->fetch(PDO::FETCH_OBJ);
foreach($result as $row){
echo $row->Task_Type;
非常感谢!
那不是它的工作原理……尝试(获得确切任务的数量):
SELECT COUNT(*) as count FROM (SELECT DISTINCT Company_Name FROM salesplus WHERE `Task_Type` = 'Form Sent' AND `Consultant_name` = 'Name Surname') as s
或更好(获取公司列表以及每个公司的选定任务计数):
SELECT `Company_Name`,count(*) as count FROM salesplus WHERE `Task_Type` = 'Form Sent' AND `Consultant_name` = 'Name Surname' GROUP BY `Company_Name`
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句