如何在下面的 $query 中添加 select COUNT 和 DISTINCT？如果您需要任何其他詳細信息來解決此問題，請告訴我。感謝您的時間。if(isset($_POST["intake_year"])){ $query = " SELECT * FROM marketing_data WHERE intake_year = '".$_POST["intake_year"]."' "; $statement = $connect->prepare($query); $statement->execute(); $result = $statement->fetchAll(); foreach($result as $row) { $output[] = array( 'semester' => $row["semester"], 'student_matric' => floatval($row["count"]) ); } echo json_encode($output);}//SELECT count(student_matric) AS count, semester, intake_year FROM marketing_data GROUP BY intake_year - 此查詢僅用于 COUNT student_matric//SELECT DISTINCT semester FROM marketing_data ORDER BY semester DESC - 此查詢僅針對 DISTINCT 學期
1 回答
蠱毒傳說
TA貢獻1895條經驗 獲得超3個贊
我想你正在尋找類似的東西
$query = "
SELECT distinct semester , count(student_matric) as count FROM marketing_data
WHERE intake_year = '".$_POST["intake_year"]."'
Group by student_matric " ;
- 1 回答
- 0 關注
- 191 瀏覽
添加回答
舉報
0/150
提交
取消