FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » Imported messages » comp.lang.php » Adding (Add - Subtract) values from two different tables to another table
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
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 Go to previous messageGo to previous message
Daniel Pitts is currently offline  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
[Message index]
 
Read Message
Read Message
Read Message
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) ] [ RSS ]

Current Time: Mon Dec 23 00:20:14 GMT 2024

Total time taken to generate the page: 0.04172 seconds