[RESOLVED] Sum of Field

[TheIrishThug]

I have a query Score that finds the score for a specific person in each record. In addition to each individual score, I need the total sum of all the scores.

for ($i=0; $i<mysql_num_rows($queryCash); $i++)
{
  $PlayerTotalScore += mysql_result($queryCash, $i, Score);
}
...
echo $PlayerTotalScore;
...
while ($rsCash = mysql_fetch_array($queryCash, MYSQL_ASSOC))
{
...
}

Doesn't work because (I assume) it's already reached the last record.

So I have two questions. Is there away to do what I'm doing above that doesn't leave the result at the last record?
Or is it less sever load to do two seperate queries (one to selecte the sum of the scores and one for each individual record)?

[bradgrafelman]

I'm not sure I understand your question very well... but can't you just select the SUM at the same time?

SELECT SUM(`field_to_add`), `field2`, `field3` FROM ...

[Roger_Ramjet]

In reply to your question, yes it is because you have reached the end of the recordset. You need to use mysql data seek to reset the pointer/cursor to the beginning again.

In this case that is not neccessary, you can just process the resultset once keeping a track of the total as you go and then outputting it.

[TheIrishThug]

Thanks, that's what I needed.