Re: Display sum of table in one line of text?

[Matthew Jones]

hmmmmm.
Yea, it sort of looks like what I am after, but Im not exactly sure how I would make it function.

I just want it to say:

Total Number of Terrorist Killed = (Total of Kills column here)
Total Number of Friendly Losses = (Total of Deaths column here)
Team Skill Score = (Total Kills / Total Deaths = Score)



I figured that if I can make one line work, it is just a case of copying the same bit of code for the other, modifying the differing values between them.

I have tried many variations of code, but the most I managed to get displayed was 'Resource Id=6'. lol

I am a complete novice to php/mysql (started learning on Saturday), so please make things very clear. I have looked at those MySQL reference manuals, and tbh, they are very hard to follow for someone who is completely new to it. :(

Thanks for your help. :)