> "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
