Show Gross Sales

I have a shopping cart and it uses Paypal's IPN that posts all orders to my database. Paypal IPN has a field called payment_gross in my table and I want to calculate all sales that I do in a total.



Any help would be appreciated

Thanks
Mark

select sum(payment_gross) as total_gross from paypal_table blah blah blah... You can decide on the where clause based on your requirements. You would then refer to total_gross in the result set returned.

Thanks works great!

Mark

here's what I used for reference to someone else !

////////////////////////////
$gross=mysql_query("SELECT SUM(payment_gross)AS total_gross from My_paypal_ipn", $dbi);
while(list($payment_gross, $total_gross) = sql_fetch_row($gross, $dbi)) {
OpenTable();
print "<center>Gross Sales: $$payment_gross</center>";
/////////////////////////
$dbi is your database settings!!!!