2016-05-12 12:53
浏览 46


i have two table, one is post table and other one is comment table.in which i am using post_id as foreign_key. Now i want to get, a post with all its comments. and response should be in this format.


Can any one write simple SQL query for me for this type of response?

I tried below query in codeigniter , but this return multiple result, mean one post two time, because one post contains two comments.

  $this->db->select("p.post_id,p.post_desc,p.post_time ,c.id,c.comment_desc,c.comment_time");
  $this->db->join("asoc_comments as c","p.post_id = c.post_id","INNER");
 $response = $this->db->get("asgn_posts as p")->result();

图片转代码服务由CSDN问答提供 功能建议

我有两个表,一个是post表,另一个是comment table.in我使用post_id作为foreign_key 。 我现在想要的,一篇包含所有评论的帖子。 并且响应应该采用这种格式。

“注释”:[{\  n“comment_id”:1,
 <\ <  / code>  


我在codeigniter中尝试了以下查询,但是这次返回 多个结果,意味着一个帖子两次,因为一个帖子包含两个评论。

  $ this-&gt; db-&gt; select(“p.post_id,p.post_desc,  p.post_time,c.id,c.comment_desc,c.comment_time“); 
 $ this-&gt; db-&gt; join(”asoc_comments as c“,”p.post_id = c.post_id“,”INNER“  ); 
 $ response = $ this-&gt; db-&gt; get(“asgn_posts as p”) - &gt; result(); 
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

3条回答 默认 最新

相关推荐 更多相似问题