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. The Topics query groups messages by topic to provide a list of available topics.

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.

Topics

There is no separate table to keep track of topics. Instead, the Topics query simply groups messages by topic and counts how many there are of each. The LastPost field records the date of the most recent message in each topic. Queries like this one are constructed using the SQL aggregate functions COUNT and MAX, together with the GROUP BY keyword. Check your database documentation for more information.