DBookatay Posted September 23, 2007 Share Posted September 23, 2007 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 More sharing options...
marcus Posted September 23, 2007 Share Posted September 23, 2007 SELECT SUM(row) AS thesum FROM `table` WHERE `this`='that' Link to comment https://forums.phpfreaks.com/topic/70316-solved-totaling-the-values-of-a-row/#findComment-353244 Share on other sites More sharing options...
DBookatay Posted September 23, 2007 Author Share Posted September 23, 2007 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... Link to comment https://forums.phpfreaks.com/topic/70316-solved-totaling-the-values-of-a-row/#findComment-353248 Share on other sites More sharing options...
DBookatay Posted September 23, 2007 Author Share Posted September 23, 2007 Got it... $query = "SELECT SUM(amtPaid) 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]; Link to comment https://forums.phpfreaks.com/topic/70316-solved-totaling-the-values-of-a-row/#findComment-353249 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.