I am developing a tree view forum with PHP, MVC, and AJAX. My database has two tables, as follows:
thread
- id_thread
- name
- creator
- date
- description
- parent_id
answer
- id_answer
- answer
- message
- user
- date
I am trying to develop a forum with n threads, that I would like to visually present in a tree view. I am confused on how to get started with creating this tree view.
My approach is in the first level of threads is just autoincrement, then when the user click a thread, the parent_id of the next thread is the parent_id of the fist level, and so on. Is there a better way to structure my data?
Any advice would be helpful, as I am a beginner trying to get started. Thank you for your time.