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

[DBookatay]

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?

[marcus]

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

[DBookatay]

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...

[DBookatay]

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];