Adobe
GoLive 6 Dynamic Content Samples
Overview
Database Design
Topics
Messages
Create Topic
Manage Topics
Manage Messages
Delete Topic
Delete Message

text

Each user posting is stored as a record in the Messages table.

Messages

Each message has a topic, a date, a username, and a unique ID that is assigned by the database. GoLive adds a reference to the message ID whenever a page uses Show Details of Current Record.

Not all databases provide an autonumber field like message ID. In this sample the combination of Topic, Username, and MessageDate is a unique record key, so the ID field is not really necessary. All of the User Forum pages would continue to work without it.