Page 1 of 1

mysql query problem

Posted: Tue Mar 17, 2009 12:53 am
by ullasvk
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.

Re: mysql query problem

Posted: Tue Mar 17, 2009 3:57 am
by jhack
http://www.php.net/mysql_fetch_row

see user notes for examples