Function Problems

[jasonmartin]

Below is a function that I am trying to get working. The first two queries in the function work (I know this because I echoed there values), but the 3rd part of the function just doesn't work. It grabs the correct data from the query, but I can't add the variables together that it retrieves.

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

Any help is greatly appreciated.

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);

// This is where the trouble begins

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

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

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

// This part of the function gives this result:

// 39 + = 39
// 40 + = 40
// 40

}

return $handicap

}

[melvyn]

Jason Martin wrote:

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

So, php does exactly as expected:
SELECT total AS scores FROM..

meaning, there's only 1 resultfield per row.

$row3[1] doesn't exist.

Maybe you'd want: total,scores?

[jasonmartin]

No. I just want to be able to add the results of the array together & then divide that total by another number. I need to find a way to select each individual variable from the array so I can add them together.

Below is the latest I have, but alas it does not work.

Thanks

Jason M

$query = "select total from rounds where name = '$player_name' order by total LIMIT 2";
$query_result_handle = mysql_query ($query);

make sure that we recieved some data from our query

$num_of_rows = mysql_num_rows ($query_result_handle);

use mysql_fetch_row to retrieve the results

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

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

echo $handicap_2;
// this just displays both of the numbers from the array together - I can't manipulate them.
}

[Anon]

Try this:

$total=0;

$query = "select total from rounds where name = '$player_name' order by total LIMIT 2";
$query_result_handle = mysql_query ($query);
$num = mysql_numrows($query_result_handle);

for($i=0;$i<$num;$i++)
{
$row[$i]=mysql_fetch_array($query_result_handle);
$each_total[$i]=$row[$i]["total"];

$total+=$each_total[$i];
}