[SOLVED] Mysql query and add results in field

[acctman]

hi i need to mysql query table rate_referrals then WHERE ref_userid = $userid and add up all the results in ref_points for the selected $userid

 

 

[Barand]

SELECT SUM(ref_points) as totalpoints FROM rate_referrals WHERE ref_userid = $userid

 

(moving to mysql forum)

[acctman]

SELECT SUM(ref_points) as totalpoints FROM rate_referrals WHERE ref_userid = $userid

 

(moving to mysql forum)

 

so totalpoints is just a place holder for the sum?

 

something like this would work?

$en['totalpts'] = mysql_query("SELECT sum(ref_points) totalpoints FROM `rate_referrals` WHERE `ref_userid` = '{$userid}' ");

[Barand]

something like this would work?

$en['totalpts'] = mysql_query("SELECT sum(ref_points) totalpoints FROM `rate_referrals` WHERE `ref_userid` = '{$userid}' ");

 

No.

<?php
$res = mysql_query("SELECT sum(ref_points) as totalpoints FROM `rate_referrals` WHERE `ref_userid` = '{$userid}' ");
$en['totalpts'] = mysql_result($res,0,'totalpoints');
?>