![]() |
![]() |
![]() |
|
![]() |
|||
![]() |
|||
![]() |
GoLive 6 Dynamic Content Samples | ||
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
||||||
Main View | Administration View | How it Works | ||||||
![]() |
||||||||
![]() |
|
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. MessagesEach 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. TopicsThere 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. |