PHP MYSQL how to count items whilst selecting [duplicate]

Question

I've reached a point in my programme where i am stuck.

I would like to have my code so that it selects everything in my database but also counts each duplicate value.

my current mysql code is:

$sql = "SELECT * FROM $country_category ORDER BY stage_limit_timer DESC, contract_name ASC";

This displays my products as follows:

red football
blue football
green football
red football
green football
etc.

I would like my products to be display as:

red football (2)
blue football (1)
green football (2)
red football (2)
green football (2)

I don't want to merge the duplicates just to count them (Would i do this in PHP or mysql?).

Any help with this would be massively appreciated. Thanks

Sorry but if you have more than one of these results that query does not show what you say it does without being processed in some way by your PHP code. — RiggsFolly
– RiggsFolly, Commented Aug 16, 2018 at 9:31

danblack · Accepted Answer · 2018-08-16 09:31:13Z

2

Something like:

SELECT product, count(*) as count FROM $country_category GROUP BY product

answered Aug 16, 2018 at 9:31

danblack

14.9k2 gold badges27 silver badges49 bronze badges

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

1 Answer 1