From: Peter F. Brown
Date: April 8 1999 10:26pm
Subject: Re: Disucssion Database in MySQL - code release
List-Archive: http://lists.mysql.com/mysql/1574
Message-Id: <199904090724.AAA15829@snipe.prod.itd.earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7BIT

> "Stephen F. Johnston Jr." <stephenj@stripped> said...
> Subject: Disucssion Database in MySQL
> For now I do not want to get into actually
> programming threaded discussions, however I would like to lay the
> groundwork by treating every message for now as a top level message in a
> threaded discussion list. So... I am wondering what type of db structrue I
> would need. I was thinking of something like this.....

Dear Stephen (and others who may be interested),

   I've just released v09.0 of "FutureForum Web Discussion Software",
programmed in Perl, with MySQL, DBI:DBD and CGI.pm.

   It's Open Source, and is availabe at:
   "http://futurerealm.com/forum/futureforum.htm"

   The table structure is in the cgi file as a comment. I use a
"branch_no" methodology, with the suffix "-top" to allow reverse sorting
of threaded messages, while still keeping each branch together.

   I welcome any comments!

   P.S.... Monty, perhaps when it's at v1.0, could it be posted in
your contrib list?

Yours,

Peter F. Brown

..........................................................................
Perl and MySQL Programmer (Web and Database programming)
(757) 468-6848 / (757) 468-6461 (fax) / Official Extropia.com Developer

worldcommunity.com - Web Hosting, Design, CGI Programming, SQL Databases
futurerealm.com - HeartThread Page on Marriage, Parenting, Family, Society
musicviews.com - MusicViews by Kim Korman Brown - Reviews of Music
wtne-sales.com - Washington Times National Weekly - Get 4 FREE Issues Here