Can I make a simple forum (no avatar and such, just making new topic and posting replies) application based on MySQL and PHP?This is my idea of the databases, i'm very green in databasing, i've learned some from Microsoft Access's lesson from school though:database one contains the topic name, topic ID, topic starter, number of replies, and date/time:
---------------------------------------------------------field name | primary key | type |---------------------------------------------------------topic_ID | yes | auto_increment |---------------------------------------------------------topic_name | no | string |---------------------------------------------------------topic_starter | no | string |---------------------------------------------------------sum_replies | no | tinyint |---------------------------------------------------------date/time | no | date |---------------------------------------------------------
Then i have database two that contains the topic ID (to relates with database one), replies, name of replier, reply no., date and time of the replies:
---------------------------------------------------------field name | primary key | type |---------------------------------------------------------topic_ID | yes | tinyint |---------------------------------------------------------replies | no | string |---------------------------------------------------------reply_by | no | string |---------------------------------------------------------reply_no | no | int |---------------------------------------------------------date_time | no | date |---------------------------------------------------------
I thought i'd just make a relationship between database one and two with the topic_ID. I know it's lame and slow, but I don't know how else to make a relationship between them.All i know is that each topic must has a table that contains the replies/posts data, but can you put a table inside a table?