Counting problems

[Kinneh]

Hiya,

I am in the process of making a clan website with interaction with a mysql database.

I have a page where i display results. I am using a results table in MYSQL to display the results. In this mysql table, i have a field called "score", where i insert a number of what we scored in the game (i.e. 12).

On a different page on the website, i have a result statistic section where it counts how many games i have won/lost etc.

The problem is how can i count "Total Score". I want to count every "score" on each row and add them all together to give me a final/total number.

Any advice would be great.

My next problem is that i want to do a "Streaks" section.
Also in my results database, i have a field called "Outcome", where it displays whether the game was won/lost or drawn.

I need to count the number of wins the clan has had, without losing or drawing a match, but i have no clue what so ever how to do this.

Again, help would be great and muchly appreciated.

Kinneh

[siwis]

Drag the numeric contents into an array via a query then:

$run_total = 0;
while ($game_score = mysql_fetch_array($query)){
$run_total = $run_total + $game_score['score'];
};

This should add each score from each successive row to the cumulative total $run_total.

Dunno about streaking tho.

[siwis]

The following assumes that you have only 3 scores (0 = lose, 1 = draw, 2 = win)
For your site, you once again need to loop through all the rows, concactenating the scores into a long single string then:

<?PHP
$outcome="012220221111222222222222220011212100201";
$outcomes_arr = explode("0", $outcome);
while($outcome_split = each($outcomes_arr)) {
$streaks = $outcome_split['1'];
$streaks_arr =  explode("1", $streaks);
	while($streak = each($streaks_arr)) {
	$streak_run = $streak['1'];
	$streak_length = strlen($streak_run);
		if ($streak_length > $streak_max_length) {
		$streak_max_length = $streak_length;
		};
	};
};
echo "Streak Max Length - $streak_max_length";
?>

The above satisfactorarily produced a result of 14 based upon the $outcome variable declared at the top. ie it successfully logged the 14 2's appearing in one long row.

[edwardsbc]

You can get the total scores using SQL:

SELECT sum(scorefield) AS totalscore FROM yourtable WHERE teamfield=teamyouwant

or

SELECT sum(scorefield) AS totalscore FROM yourtable GROUP BY teamfield

[siwis]

Well, I learned then too!
Cheers ed!