Array Sum Help

Anon

Hi!

I've encountered a problem that I just can't solve...Here is what I am trying to do: (This is just an example, but I think it will get my idea across).

I want to select all of the record from my db that meet a certain criteria, like select all of my members that are from the United States (for example).

Then I want to select all of of the values in the 'Points' column where the criteria was met, and add all of these values together.

Problem is, PHP only takes the last record that shows up. I don't know how to add between rows...I'll provide another example to try to clarify:

User Points
john 13
jane 21
dave 7

I want to select those three records and be able to get the correct sum of 41.

Please tell me if this is possible, and if it is, please give me some guidance so I can figure this out...

Thank you so much for your time,
Barry

Anon

$n=0;
$db=mysql_connect("host","user","pass");
mysql_select_db("database");
$res=mysql_query("SELECT * FROM table",$db);
while($row=mysql_fetch_array($res)){

$user=$row[#of field of user];
$points=$row[#of field of points];
$n++;
$totalpoints=($totalpoints+$points);
}

echo "$n entries totaling $totalpoints points";

Anon

"SELECT SUM(points) AS totalpoints FROM table WHERE origin='United States'"

for appropriate values of "points", "table" and "origin"

doesn't work?

Anon

This is what I tried:

<?php

if ($submit) {

$db = mysql_connect("host", "user", "pass");

mysql_select_db("db",$db);

$sql = "SELECT SUM(points) AS totalpoints FROM membertest WHERE referrer='$user'";
$result = mysql_query($sql);

echo "$totalcoinz\n";

}

else {

<form name="nmtestform" method="post" action="<?php echo $PHP_SELF?>" ONSUBMIT="return valid()">
<font face="Verdana, Arial, Helvetica"><font size="2"><center>Member ID<p>
<input type="text" name="user" size="40" maxlength=100><br>
<input type="Submit" name="submit" value="Submit Form!">
</form>

<?php

}

When I try it an click submit, it just shows a blank page and I can't figure out why.

Anon

Thanks!

I misunderstood your code at first, but after a few tries I got it work...

To me it doesn't seem like it should work, and I don't really know why or how it works (the n++ confuses me a bit), but that doesn't matter too much.

Anyways, thanks for all your help!

Anon

$totalcoinz?

Anon

if ($submit) {

$db = mysql_connect("host", "user", "pass");

mysql_select_db("db",$db);

$sql = "SELECT SUM(points) AS totalpoints FROM membertest WHERE referrer='$user'";
$result = mysql_query($sql);
$totalpoints=mysql_result($result,0,'totalpoints');
echo "$totalpoints\n";

}