problem in using while loop in php&mysql

Question

im using a while loop to show my latest forum topics and count some fields

I'm trying to do it in one query and here is my code :

  SELECT t.*,p.*,
       SUM(t.topic_approved='1') AS Amount_Of_Topics,
       SUM(t.topic_views) AS Amount_Of_Topic_Views,
       SUM(t.topic_replies) AS Amount_Of_Topic_Replies, 
       SUM(p.post_approved ='1') AS Amount_Of_Posts
    FROM  bb3topics t left join  bb3posts p ON t.topic_id=p.topic_id
    ORDER BY t.topic_last_post_id DESC LIMIT 10

problem :

this code shows only one forum topic and not the rest

is there anything wrong with my query code ?!

Salil is right, you probably need GROUP BY. Read about it. — Felix Kling
– Felix Kling, Commented May 29, 2010 at 10:12

Salil · Accepted Answer · 2010-05-29 10:05:13Z

3

Yes.

SUM is always used with GROUP BY clause

answered May 29, 2010 at 10:05

Salil

47.7k22 gold badges127 silver badges161 bronze badges

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

1 Comment

Felix Kling Over a year ago

That is not true. It is not always used with GROUP BY. But in this case it is indeed what the OP needs.

G-Rajendra · Accepted Answer · 2012-01-21 01:44:05Z

1

Yes you are missing GROUP BY.

edited Jan 21, 2012 at 1:44

user212218

answered May 29, 2010 at 10:10

G-Rajendra

2157 silver badges17 bronze badges

Collectives™ on Stack Overflow

problem in using while loop in php&mysql

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related