Ok, i'm working on finishing the structure for a small set of forums on my site.
I have a forums db which lists the main forums
a topics db with lists the topics with a topic id.
and a thread db which houses all the threads.
Now when you view the topic it will list all the threads and my sql statement basically says, show all threads with the topic_id of the topic they clicked on. Simple enough right?
Well, my problem is the first post or when somebody creates a new topic. I have to post the topic (subject of the new topic) to one db (topics) and then the body to the other db (threads).
Is their an easier way of doing this?
I've been fighting with this for quite a while and any help would be very appriciated.
Anthony
