FUDforum: comp.lang.php » Adding (Add - Subtract) values from two different tables to another table

Home » Imported messages » comp.lang.php » Adding (Add - Subtract) values from two different tables to another table

Show: Today's Messages :: Polls :: Message Navigator

Re: Adding (Add - Subtract) values from two different tables to another table [message #182421 is a reply to message #182420]

Sun, 04 August 2013 04:31

Daniel Pitts
Messages: 68
Registered: May 2012

Karma:

Member

On 8/3/13 8:54 PM, vikas daiya wrote:
> am developing inventory page in php with database as mentioned below. I have some complex equation which I am unable to resolve. Please help me out.
>
> I have one table name "A" with column X and Y having values as follows:
>
> Table "A"
>
> ------------
> X Y
> ------------
> blue 0
> yellow 0
> brown 0
> Table "B" in following pattern.
>
> ------------
> X Y
> ------------
> blue 50
> yellow 15
> blue 20
> brown 5
> similarly Table "C"
>
> ------------
> X Y
> ------------
> blue 15
> yellow 10
> blue 5
> brown 5
> Now what I want if I add record in table "B" as mention above it should be updated in table "A" with following equation.
>
> "A"= "B"-"C"
>
> result should be i.e
>
> Table "A"
>
> ------------
> X Y
> ------------
> blue 20
> yellow 5
> brown 0
> same in case of adding in records table "C" equation should be as follows:
>
> please note X values in table "A" are DISTINCT where as in other table are not.
>
This sounds more like a SQL problem then PHP.

Try something along the lines:

select sum(B.y) - sum(C.y) from B, C on B.x=C.x group by B.x

Report message to a moderator

[Message index]

		Adding (Add - Subtract) values from two different tables to another table By: vikas daiya on Sun, 04 August 2013 03:54
		Re: Adding (Add - Subtract) values from two different tables to another table By: Daniel Pitts on Sun, 04 August 2013 04:31
		Re: Adding (Add - Subtract) values from two different tables to another table By: Jerry Stuckle on Sun, 04 August 2013 13:47

Previous Topic:	ini_get("memory_limit") returns an empty string
Next Topic:	Hopiing for some leads as to what may be wrong in this code

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 19:55:09 GMT 2024

Total time taken to generate the page: 0.05049 seconds