Fusioncharts / php / mysql

Fusioncharts / php / mysql I have a table called “tickets” in a database called “jazzfunk_cmms” I need two fusioncharts generated from this table 1:-A field called “status“ contains an integer of values 0, 1 or 2. I require a 3D Pie chart of the amount of times each occurs in the table. The meaning of this field is as follows 0 = Open, 1 = In Progress, and 2 = Closed That’s the easy bit! Now the tricky part 2:- This table also contains a field called “assigned” This field contains an array in the as follows. ***U1U***U3U which means User 1 and User 3 are included the record These need to be exploded, cleaned (so we just get 1 or 2 or 3 etc.), and joined to a table called “users” by [login to view URL] where I need to display “[login to view URL]” on the JOIN and finally in the Fusion chart. Finally I require this to be put in a 3D stacked chart with reference to the “status” field as follows How many times does the “assigned” user appear WHERE “status” = 1 How many times does the “assigned” user appear WHERE “status” = 2 X axis displays [login to view URL] Y axis displays number of jobs (i.e. 1 = in progress and 2 = closed).