sum of sum

[amkma]

Hi everyone.
Good day.

I have a table 'payments' with 9 fields.
id,
client_name,
total_amount,
deposit_paid,
deposit_paid_on_date,
1st_installment,
installment_paid_on_date,
2nd_installment_paid,
2nd_installment_paid_on_date

I want to get the the sum of each payment, for which I have used the 'sum()' in the query.

But how can I get the sum of the sum (deposit_paid + 1st_installment + 2nd_installment) received today.

Regards.

[amkma]

I have tried these, But no luck.

$curdate=date("YmdHis");

$result=mysql_query("SELECT SUM(deposit_paid) AS depo + SUM(1st_installment) AS secpay + SUM(2nd_installment) AS thirdpay FROM payments WHERE deposit_paid_on_date = $curdate or installment_paid_on_date = $curdate or 2nd_installment_paid_on_date = $curdate");

OR

$result=mysql_query("SELECT SUM(deposit_paid + 1st_installment + 2nd_installment) AS totpay FROM payments WHERE deposit_paid_on_date = $curdate or installment_paid_on_date = $curdate or 2nd_installment_paid_on_date = $curdate");

while($row = mysql_fetch_array($result)){

echo "Total payments today= £ ". $row['totpay'];

}


where am I going wrong here? No error just doesnt display anything... Is this type of query even possible?