Function Help

jasonmartin

I have the function below that works until it gets to the for loop. It grabs the two correct scores, but when I try to add them together it gives me just the last score.

Any help is greatly appreciated.

Thanks,

Jason Martin

function GetHandicap ($player_name)
{
global $dbname;

$results=mysql($dbname,"select count(*) as count from rounds where name = '$player_name'");

$row=mysql_result($results,"count");

$results2=mysql($dbname,"select rounds_used from handicap_table where rounds = $row");

$row2=mysql_result($results2,"rounds_used");

$query = "select total as scores from rounds where name = '$player_name' order by scores asc LIMIT $row2";

$query_result_handle = mysql_query ($query);

for ($counting = 1; $row3 = mysql_fetch_row ($query_result_handle); ++$counting)
{

echo $row3[0];
// This gives me the first score - 39
echo $row3[1];
// This gives me the second score = 40

$handicap = $row3[0] + $row3[1];
// This gives me the same as $row3[1] 40. It should be 79
}
return $handicap;

}

Thanks,

Jason Martin

jasonmartin

I implemented your code below instead of mine & the result was:

39 + = 39
40 + = 40
40

while ( $row3 = mysql_fetch_row($query_result_handle)) {

echo "$row3[0] + $row3[1] = " . ($row3[0] + $row3[1]) . "<br>";

$handicap = $row3[0] + $row3[1];

}

Basically all I want to do is all of the values together that this query retrieves & divide by the result of another variable.

Thanks,

Jason Martin

mathieu

Your row has only 1 columns, hence it can't sum up stuff like that. You can however use the aggegrate function SUM() which resides in both MySQL and PostgreSQL:

$q_res = mysql_query("SELECT SUM(total) AS scores FROM rounds WHERE name = '$player_name' ORDER BY scores ASC LIMIT $row2");

echo mysql_result($q_res, 'scores');

That should output '79'.

Hope to have helped

-- Mathieu

jasonmartin

I placed the code exactly as you had in your example in to the code, but it still doesn't work. I tried the sum function earlier today & it seems to sum all of the values in that column and ignores the limit at the end of the statement.

When I put the following code in, it printed 161 which is the sum of all the 4 values in that column not just the lowest 2.

Any ideas?

Thanks,

Jason M

$q_res = mysql_query("SELECT SUM(total) AS scores FROM rounds WHERE name = '$player_name' ORDER BY scores ASC LIMIT $row2");

echo mysql_result($q_res, 'scores');

mathieu

Sigh.

Sorry to say, but.. Think a little on your own.

ok, so the sum() thing is not what you want.
to count all the values together that get through your LIMIT statement:

while ($row = mysql_fetch_row($result)) {
$handicap += $row[0];
}

You could even use mysql_result() here.

Hope it helped
Mathieu