[SOLVED] Adding Values Together Based On Another Row

[jj20051]

I Have 3 Rows, User, Approved, and Earnings. I Want To Make A Script That Will Add All The Values Of Earnings Together Based On Only Approved Users. ( I Only Want to Add The Earnings Together On Users that Are Approved )

[peranha]

SELECT SUM(Earnings) FROM table WHERE Approved = "approved";

 

Something like that would work.

[jj20051]

Here Is What I Came Up With Based Upon The Statement Above:

 

$refer = mysql_query("SELECT SUM(uCash) FROM users WHERE uReferrer = 1")
or die(mysql_error()); 


echo $refer;

 

I Get:

Resource id #3

 

Witch Basically Says There Are 3 Rows In The Database, Witch Their Are.... What Is Wrong?

[Andy-H]

$refer = mysql_query("SELECT SUM(uCash) as Earns FROM users WHERE uReferrer = 1")
or die(mysql_error()); 

$row = mysql_fetch_object($refer);


echo number_format($row->Earns);

 

[jj20051]

Now I Have One Last Small Problem, How do I Keep It From Rounding Up or Down?

[.josh]

by removing the number_format

[jj20051]

Thnks All!

[Andy-H]

You can also use number_format($row->Earns, 2); Which will round it to 2 decimal places. Assuming your working with currency. Doesnt haveto be 2 tho, can be any number.

[.josh]

...or they could just leave it out altogether, seeing as how the OP made no indication that formatting was an issue.