Hello Friends.
I am doing a project in php based on inventory management. I have a table in my database called goods i.e.,
Table : goods
D S W
9 68 75
9 68 75
9 72 100
9 72 100
9 75 150
9 75 150
10 78 200
10 78 200
10 78 200
Now i want the values retrieved as follows
D S W
9 68 150
9 72 200
9 75 300
10 78 600
Can any one please help me. I am able to get the 1st row i.e., 9 68 150 but rest of the values i am unable to get
Please give me some idea how to do this.
mysql query problem
Moderator: General Moderators