Hmmm, dunno if PHP allows composite queries - have you tried running them individually, one after the other?
Or even directly in a MySQL terminal to check the code is okay...
I THINK I DID IT XD
The sum(blah,blah,blah) as total wasn't valid - I bodged it to;
(sum(blah)+sum(blah)+sum(blah)) as total
And yay :D
omg DOUBLE HELP PETER :C
Thankyou very much as I have made it work :D
BUT! How do I make it so it only reports one of each ID?
It's turning up some IDs several times in each :'S
Yay. :D
Just change it to SELECT DISTINCT ... and it should return only one per person.
Yay
:D
Hooray XD!
Message 30653.9 was deleted