Question

我分两个表格。

my_comment_thumbs [thumb_member_id, Cmt_id, thumb]
my_Comment [id, page, member_id, comment, ip]

umb,thumb= 1 , and,thumb=0。

[Not sure if that is very clear.]

我曾试图 get上umb子, each倒每一评论。

What I ve got so far [without a full understanding of what I have...]

SELECT 
SUM(IF(thumb= 1 , 1, 0)) AS t_up, 
SUM(IF(thumb= 0 , 1, 0)) AS t_down, 
id, member_id, comment, ip 
FROM my_Comment LEFT OUTER JOIN my_comment_thumbs ON member_id=thumb_member_id 
WHERE page= 333

非常感谢任何帮助。

Answer 1

由于我没有数据集,我可以就此进行测试,我认为这项工作将会奏效——但是它没有经过测试:

SELECT 
    (SELECT count(thumb) FROM my_comment_thumbs WHERE thumb=1) as t_up, 
    (SELECT count(thumb) FROM my_comment_thumbs WHERE thumb=0) as t_down, 
    id, member_id, comment, ip 
FROM my_Comment 
LEFT OUTER JOIN my_comment_thumbs ON member_id=thumb_member_id 
WHERE page= 333

Hope that helps.

Answer 2

for thumb=1 or thumb =0 ;

"SELECT COUNT(*) FROM my_comment_thumbs,my_Comment 
   WHERE   
       my_Comment.id=my_comment_thumbs.Cmt_id 
          AND 
       my_comment_thumbs.thumb=1 
          AND 
       member_id=thumb_member_id;"

友情链接