PHP MySQL - SELECT SUM return issue

Question

I am attempting to perform the following query:

SELECT SUM(cash) AS total_cash FROM users

The query should give me back a SUM() of the total cash which I've paid out to users in the form of a field named total_cash.

My HTML/PHP is as follows:

<p class="cash_count">
$<? 
    $total_cash = $db->GetNumRows($db->Query("SELECT SUM(cash) AS total_cash FROM users"));
    echo number_format($total_cash);
?>
</p> paid out!

I know GetNumRows will always show 1 as there's only 1 row, but I don't know what to use instead, can anybody guide me?

Vishnu · Accepted Answer · 2012-12-07 23:12:07Z

1

You are using some class to connect to database - you have not specified anything about that class. If $db->Query() returns the actual mysql resource, you can do this:

$res=$db->Query("...."); 
$r=mysql_fetch_object($res);
echo $r->total_cash;

answered Dec 7, 2012 at 23:12

Vishnu

4713 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pablo Martinez · Accepted Answer · 2012-12-07 23:12:31Z

0

Yes, there's only 1 row, because your query ask for the SUM, and returns only 1 row with the sum.

You can do 2 things, or quit the SUM of the SQL or quit the $db->GetNumRows.

answered Dec 7, 2012 at 23:12

Pablo Martinez

2,1701 gold badge24 silver badges29 bronze badges

Collectives™ on Stack Overflow

PHP MySQL - SELECT SUM return issue

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related