Jump to content

[SOLVED] Totaling the values of a row...


DBookatay

Recommended Posts

I use this code:

//Count Payments
$query = "SELECT count(*) as thecount from IH_Records where type = 'Payment' and id = '{$_GET['id']}'"; $result = mysql_query($query); $row = mysql_fetch_array($result); $total_pymts = $row[thecount];

//Count Late Fees
$query = "SELECT count(*) as thecount from IH_Records where type = 'Fee' and feeType = 'Late Fee' and id = '{$_GET['id']}'"; $result = mysql_query($query); $row = mysql_fetch_array($result); $total_latefees = $row[thecount];

//Count Repos
$query = "SELECT count(*) as thecount from IH_Records where type = 'Fee' and feeType = 'Repo Fee' and id = '{$_GET['id']}'"; $result = mysql_query($query); $row = mysql_fetch_array($result); $total_repos = $row[thecount];

 

to count the number of Payments / Late Fees / Repos in my table IH_Records.

Now how do I add the values?

 

Meaning if there are 3 "$total_latefees" for 4.50, 3.00, 7.00, how do I get a total of 14.50?

Link to comment
https://forums.phpfreaks.com/topic/70316-solved-totaling-the-values-of-a-row/
Share on other sites

SELECT SUM(row) AS thesum FROM `table` WHERE `this`='that'

 

I think you mean this:

$query = "SELECT SUM(row) AS thesum FROM IH_Records WHERE type = 'Payment' and id = '{$_GET['id']}'"; $result = mysql_query($query); $row = mysql_fetch_array($result); $total_pymtsAmt = $row[thesum];

 

but it doesnt work...

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.