count and groupby together in one query

Question

The following query is fetching some product info on a page which is fine, but I also want to show the number of the product that it occurs as a text, however, I used groupby but I also want to use count on pro_id.

 "SELECT * FROM cart  WHERE session_id='" . $_SESSION['session'] . "' GROUP BY 
    pro_id  "

Duplicate of: https://stackoverflow.com/questions/2722408/how-to-use-count-and-group-by-at-the-same-select-statement — Gernot, Dec 08 '17 at 12:16
table structre is like --- cart_id (pk)--- pro_id(fk)---- pro_name---pro_price---pro_image @pravindot17 — basiclearner, Dec 08 '17 at 12:20
did you tried `$query = "SELECT pro_id, count(*) as prod_count FROM cart WHERE session_id='" . $_SESSION['session'] . "' GROUP BY pro_id "`? — pravindot17, Dec 08 '17 at 12:28

score 0 · Answer 1 · answered Dec 08 '17 at 12:15

0

Your query won't work. Try like this;

 "SELECT pro_id,count(*) FROM cart  WHERE session_id='" . $_SESSION['session'] . "' GROUP BY 
  pro_id  "

answered Dec 08 '17 at 12:15

lucky

12,734
4
24
46

score 0 · Answer 2 · answered Dec 08 '17 at 12:17

0

Use this query:

"SELECT pro_id,count(pro_id) FROM cart  WHERE session_id='" . $_SESSION['session'] . "' GROUP BY pro_id  "

answered Dec 08 '17 at 12:17

Himanshu Upadhyay

6,558
1
20
33

count and groupby together in one query

2 Answers2

Linked

Related