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

Adding (Add - Subtract) values from two different tables to another table [message #182420]

Sun, 04 August 2013 03:54

vikas daiya
Messages: 2
Registered: August 2013

Karma:

Junior Member

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.

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 Nov 10 16:31:02 GMT 2024

Total time taken to generate the page: 0.04887 seconds