SmokyHosts Support Forums - Webhosting and Webdesigning Support!

Posted: **Wed Nov 22, 2006 12:24 am**

A Question??

How Can I solve this problem in SQL ??

profit of selling_______________loses of payments___ Total_____day
12__________________________23________________-11_____11/11
26__________________________ 43____________-11+-23____12/11
34__________________________ 12 _________ -11-23+22____13/11
23__________________________ 32________-11-23+22-9 ____ 14/11
62__________________________ 21_____-11-23+22-9+41____15/11
____________________________________________________________

I want to know Total every day ???

Posted: **Thu Nov 23, 2006 6:17 pm**

u have to use php to count your total.
As i understand from your example you have to take digit from previous day and plus or minus whatever digit you need.
OR
Try to view mysql manual- i know that it can do mathematical operation.

Posted: **Sat Dec 23, 2006 11:42 am**

are you allowed to use php?

Posted: **Sat Dec 23, 2006 3:52 pm**

vinter wrote:are you allowed to use php?

Why wouldnt you be allowed to use php?

Posted: **Fri Nov 20, 2009 3:49 pm**

UGG On Sale for cheap

Posted: **Mon Nov 23, 2009 3:02 pm**

Jonxmartini wrote:Why wouldnt you be allowed to use php?

Due to the fact people can use it to hack our site... but we are still allowed to use it