SUM Function

[sam06]

My Query is to find the SUM of all values in the 'Value' column where the Username = $username

 

 

$result = mysql_query("SELECT username, SUM(Value) FROM clicks GROUP BY username WHERE username='$username'") or die(mysql_error());
$name = mysql_result ($result, 0, 'Username');

 

I am then going to use that result in a sentance like

Your total amount is '$name'

 

Many Thanks,

Sam

[fenway]

Sounds like you need to alias that exrpession.