jsoni Posted August 3, 2013 Share Posted August 3, 2013 In Question and Answer system I am trying to get comment for question and answer and the title of that comment. I have done so far and getting comment's content but now the issue is if the comment is on the answer it is not getting the question title. So how can I write query so it will get all comment from question and answer both and will get the title of the question. Here I have done so far. SELECT c.postid, p.title, c.type, c.userid, c.content, c.parentid, u.handle, u.email, u.avatarblobid, u.avatarwidth, u.avatarheight FROM qa_posts p JOIN qa_posts c ON (p.postid = c.parentid) LEFT JOIN qa_users u ON c.userid = u.userid WHERE c.type = 'C' AND p.flagcount = 0 ORDER BY c.postid DESC LIMIT 5 Here is my tables image Link to comment https://forums.phpfreaks.com/topic/280800-how-to-get-comment-content-and-the-post-title/ Share on other sites More sharing options...
ragax Posted August 3, 2013 Share Posted August 3, 2013 Cross-posted on DevShed. Make up your mind. Link to comment https://forums.phpfreaks.com/topic/280800-how-to-get-comment-content-and-the-post-title/#findComment-1443380 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.