query("SELECT tagName, COUNT(DISTINCT c.cs_code) as count
FROM tagtable t
LEFT JOIN customer c ON t.customerId = c.id
WHERE t.employeeId = " . $_SESSION['employee_id'] . "
GROUP BY tagName");
if ($result) {
while ($row = $result->fetch_assoc()) {
echo '' .
htmlspecialcharsFix($row['tagName']) . '(' . $row['count'] . ')';
}
}
?>
无标签客户