I'm not sure if this is the right place to ask my question, but I think you guys can help...
Can anybody tell me about a good way to save forum data in a MySQL database? I'm thinking about a table with four columns: user, time, reply, and msg. reply is an integer. If it's 0 then it means it's the main message, otherwise it's a reply. For example, if reply is set to '1' then it's a reply to the main message, and if it's set to '2' then it's a reply to level '1' messages, ...etc.
Although that seems to be OK, but I will then have problems with inserting data into the database since I'll need to insert specific data between two specific rows for example.
I'd really appreciate it if somebody can help me with this or tell me some other format to save data with.
Thanks in advance.