getting forums messages
Posted: Thu Dec 02, 2004 7:32 am
lets say i have these tables:
forums [id, opendate, title]
^
forums info table
forumsmessages [id, writedate, userid, content, replytoid]
^
message info: who wrote it, when, what and in reply to which messsage (if NULL, its a new message)
How do i get them all in on SELECT from the DB in the right order, the order in which i can just print them
i thank you very much if you can help me
forums [id, opendate, title]
^
forums info table
forumsmessages [id, writedate, userid, content, replytoid]
^
message info: who wrote it, when, what and in reply to which messsage (if NULL, its a new message)
How do i get them all in on SELECT from the DB in the right order, the order in which i can just print them
i thank you very much if you can help me