I am planning on making a comment-reply system inside of a site. (A simple one)
I searched through youtube related to this, and I found a good source. The problem is, he has a 2 separate queries, one for parent comment and two for reply to parent comment and what's more is that the second query is inside a
foreach loop (bad practice). So, I need to revised of how he query the comments and the tables.
This is the table I came up with:
comment_table id | post_id | comment_id | date | message | reply_id //In the source, he has 2 tables, parent and child comment table.
I want to create a single query where parent comments and child comments are get back at the same time, but I am not sure if it will work.
Let's say I have a table like this.
id | post_id | comment_id | date | message | reply_id 1 | 2 | 3 | jan 2016 | hello | 2 | 2 | 4 | feb 2016 | hello2 | 3 | 2 | 5 | mar 2016 | hello3 | 3
reply_id is where the
comment_id replied to.
I need to output this results like this:
Comments hello2 //comment hello //comment hello3 //reply
This is what I need to do:
- Get all comments in
datewhile checking if
reply_idis not empty, and if not empty, it will check it based on
My problem is, the I only thing that I know how to query is the first part and that is to Get all comments in
DESC order by
date, the rest is I do not know.
My question is, is this possible to query? If so, what
syntax do I need here? If you have a better solution than mine, please tell me.