[thelist] MySQL Tables for weblog

Lachlan Cannon tiedefenderdelta6 at yahoo.com
Sat Mar 16 04:37:01 CST 2002


I'm currently in the process of thinking out how to set up
a weblog, and I'm currently trying to think of the database
table structure I should use - I want the records to have
comments associated with them too.

Currently I'm thinking of something like this.

Table Entries
ID (key) | Title of post | Date | Entry

Table Comments

Postername | comment | email | entryid

Are there any problems with a structure set up like this?
Anyway it could be made better?

TIA

Lach

__________________________________________________
Do You Yahoo!?
Yahoo! Sports - live college hoops coverage
http://sports.yahoo.com/



More information about the thelist mailing list