php mysql count

Question

I have a table that logs how many of an item people have, table is set up like

Name        Item          Amount
--------------------------------
Knob        Pistol          5
Knee        Pistol          2
Hat         Shotgun         3

I want to loop through the table and find out the total number of certain items. So if i searched for 'Pistol', it would output 7.

Do I have to loop through each record and add them to a number count, or is there a quicker way of doing it?

Did you tried SUM with GROUP BY?

CristiC
– CristiC

2011-11-07 17:52:18 +00:00
Commented Nov 7, 2011 at 17:52 — CristiC
– CristiC, Commented Nov 7, 2011 at 17:52

Jemaclus · Accepted Answer · 2011-11-07 17:52:20Z

4

This is a basic SQL question. You really should look at the SQL docs to learn more. The function you're looking for is SUM.

    SELECT SUM(amount) as total FROM table WHERE item = 'Pistol'

This would return

    total
    -------------
    7

Good luck.

answered Nov 7, 2011 at 17:52

Jemaclus

2,3761 gold badge15 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pedryk · Accepted Answer · 2011-11-07 17:52:42Z

2

You could use the following query:

SELECT Sum(Amount) FROM table_name WHERE Item = 'Pistol'

answered Nov 7, 2011 at 17:52

Pedryk

1,6631 gold badge13 silver badges28 bronze badges

Collectives™ on Stack Overflow

php mysql count

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related