mysql query problem

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
ullasvk
Forum Newbie
Posts: 21
Joined: Fri Feb 13, 2009 11:55 pm

mysql query problem

Post 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.
jhack
Forum Newbie
Posts: 10
Joined: Wed Mar 11, 2009 9:46 pm

Re: mysql query problem

Post by jhack »

http://www.php.net/mysql_fetch_row

see user notes for examples
Post Reply