how to count number within a DB field

[hossfly007]

I am trying to count how much money a person has won and i cant find the right forumula for it.

 

Here's an example:

 

TABLE_MONEY

>>ID

>>DATE

>>NAME

>>MONEY_WON

 

ID DATE NAME MONEY_WON

1 4/1 Jon 50.00

2 4/1 Tim 20.00

3 4/2 Jon 10.00

4 4/2 Tm 15.00

 

could someone show me a code that would tell me how much money Jon and Tim made? or a link to an example (if it's to complex)

 

 

 

[per1os]

SELECT SUM(monkey_won) FROM table_money WHERE NAME IN('Jon', 'Tim');

[hossfly007]

frost your awesome man thanks alot

[hossfly007]

ok one more thing, hate to be a newb again, but i cant get it to work... please help one more time

 

 

$query = "SELECT SUM(money_total) as cash FROM TABLE_MONEY WHERE NAME IN('Jon')";
$r1 = mysql_fetch_array($query);
$stats['cash'] = $r1['cash'];
$text .= "{$stats['cash']}";
}

[MadTechie]

whats the error ?

[hossfly007]

nothing shows up, it's just blank, yes there is data in the field. =]

[MadTechie]

can you post the part thats displays the results

[hossfly007]

$query = "SELECT SUM(money_total) as cash FROM TABLE_MONEY WHERE NAME IN('Jon')";
$r1 = mysql_fetch_array($query);
$stats['cash'] = $r1['cash'];
print = "{$stats['cash']}";
}

[MadTechie]

humm

 

try

 

$query = "SELECT SUM(money_total) as cash FROM `TABLE_MONEY` WHERE `NAME` IN ('Jon')";
$r1 = mysql_fetch_array($query);
print_r($r1);
}

[per1os]

I thought the column name was money_won...