Count mysql entries with same value in php?

Question

In mysql, I have the following information:

Article_Name   Category_ID
-------------  -----------
Penguins            20
Lions               20
Tigers              20
Electricity         21
Power Plants        21
Buddhism            22

I want to count the number of articles, or I guess you call them "entries", with the Category_ID "20". Is there a function php function I can call to find the number of articles with Category_ID "20"?

fancyPants · Accepted Answer · 2013-07-23 15:13:03Z

3

SELECT COUNT(Article_Name) FROM yourTable WHERE Category_ID = 20

answered Jul 23, 2013 at 15:13

fancyPants

52.1k34 gold badges94 silver badges100 bronze badges

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

Collectives™ on Stack Overflow

Count mysql entries with same value in php?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related