i have the following query
FROM tbl_jobs AS job
LEFT JOIN tbl_job_department AS jdept ON job.jobID = jdept.jobID
LEFT JOIN tbl_job_location AS loc ON job.jobID = loc.jobID
LEFT JOIN tbl_places AS place ON loc.placeID = place.placeID
LEFT JOIN tbl_departments as dept ON jdept.deptID = dept.deptID
WHERE place.placeID = $placeID
and can easily get the total records by using mysqli_num_rows on the above query, but i also want to get a total count of the unique deptID's within the same query.
so i can return something like "12 jobs found from 4 departments"
can anyone help please?