Hi there,

I am trying since morning to make a simple pie chart based on the following SQL :

SELECT prj_pf_projects.title as qry_project, count( * ) as qry_tasks
FROM `prj_pf_tasks`, `prj_pf_projects`
where prj_pf_tasks.project_id = prj_pf_projects.id
GROUP BY prj_pf_projects.title
ORDER BY prj_pf_projects.title

The result of this query is as follows :

Project1 3
Project2 1

I need help ..!!!

Hello,

Could you send SQL dump of `prj_pf_tasks`, `prj_pf_projects` tables (you can send it with fake data) and an image where we can see what do you want to achieve by email?

Regards,
ARI Soft