Entry threads

[Shroder01]

I'm attempting to create a forum. Kind of like this one here although its really simple now and my first attempt on creating a design for how everything will handle threads has failed me.
Basicaly I started off having a thread and a subthread. I was doing this mostly to figure out which thread was the first (main) thread. But I found that if I deleted a subthread the numbering would be all messed up.
So I'm wondering if there is a way to have all entries under the same thread and be able to make a mysql query that takes only the first thread of each thread group.

Basicaly, I'm wondering how you get a listing of the differnt (unique) threads.

Help is appreciated! Thanks!

[autumn]

when building a system like this, what I recommend is you create a table for all the parent/main threads. Then create another table for all child/reply threads and you create a field which tell which parent id it belongs to.

Now you can have as many replies to the main thread and can hide/show them as you please.

When deleting sub-threads you can just delete the records from the child table, but when deleting the main parent thread, you have to tell the page to delete all child records with the same parent id as the actual parent record.

Hope that helps.

A

[Shroder01]

sounds good. Thank you! 🙂