Need help with data arrays

This gives me to total of event type 1 and the total of event type 2 between the relevant dates for each member of staff. The result set contains the staffid 3 times (once from the SELECT * and once each because of the select in the subqueries) and I don't know how to get rid of the two 'extra' ones.

Oh, cool, that's easy! Instead of doing SELECT *, just name the fields that you want.

From your two subqueries, I think you only need the SUM() fields, a.total_absence and s.total_sickness.

also, is this solution a good one or could I have done better?

I played and played with it and couldn't find anything better. I think you got it! Don't forget the COALESCE() tip I posted below. I tested it, and it works.

That was a great question you posted! I learned from trying to find a solution!

Hey, don't work without a PHP debugger. Several free IDEs have this features built in. Two are NetBeans and CodeLobster. Without a debugger, it's like you're driving with a blindfold on -- you are going to crash!