RE: [PHP-DB] Theory help needed
http://users.starpower.net/rjhalljr/Serve/MySQL/traer.html -Mensagem original- De: Cal Evans [mailto:[EMAIL PROTECTED]] Enviada: sexta-feira, 20 de Dezembro de 2002 5:07 Para: Chris Payne; [EMAIL PROTECTED] Assunto: RE: [PHP-DB] Theory help needed Read today's thread about trees. It contains the info you need. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 10:24 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Theory help needed Hi there everyone, I have a messageboard which works, but what I need is some kind of threading for it. Right now I have EXTREMELY basic threading, where you can reply to a message, reply to replies etc . and they'll appear in the correct part of the messageboard. What I need though is to be able to do proper threading, where each reply appears under the original message and not all over the place, but i'm confused as hell. Anyway have any experience with this kind of thing and can give me a push in the right direction? I know I need to store the original ID, the forum ID, the message ID of the current message and the ID it relates to, but it's getting confusing :-) Thanks. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Theory help needed
why not use one of the existing forum software? phorum? FUDForum? Sincerely berber Visit http://www.weberdev.com/ Today!!! To see where PHP might take you tomorrow. -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 6:24 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Theory help needed Hi there everyone, I have a messageboard which works, but what I need is some kind of threading for it. Right now I have EXTREMELY basic threading, where you can reply to a message, reply to replies etc . and they'll appear in the correct part of the messageboard. What I need though is to be able to do proper threading, where each reply appears under the original message and not all over the place, but i'm confused as hell. Anyway have any experience with this kind of thing and can give me a push in the right direction? I know I need to store the original ID, the forum ID, the message ID of the current message and the ID it relates to, but it's getting confusing :-) Thanks. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Theory help needed
i'm not experienced so this is just a theory. if you have a parent id field in your tables then each reply would have the parent id of the original message they replied to, so when your program gets the data it will get the original message, and then get any other messages with the same parent id, then it would move on and get the next original message...etc. e.g. to get original message: select message_body,message_id from message_table then to get the threads of the original message: select message_body,message_id from message_table where parent_id=[message_id of original message] i know thats a vague description but its an idea...i guess.. On Fri, 2002-12-20 at 15:23, Chris Payne wrote: Hi there everyone, I have a messageboard which works, but what I need is some kind of threading for it. Right now I have EXTREMELY basic threading, where you can reply to a message, reply to replies etc . and they'll appear in the correct part of the messageboard. What I need though is to be able to do proper threading, where each reply appears under the original message and not all over the place, but i'm confused as hell. Anyway have any experience with this kind of thing and can give me a push in the right direction? I know I need to store the original ID, the forum ID, the message ID of the current message and the ID it relates to, but it's getting confusing :-) Thanks. Chris signature.asc Description: This is a digitally signed message part
RE: [PHP-DB] Theory help needed
I would recommend phpBB ... very useful and best of all, FREE! :) http://www.phpBB.com -Original Message- From: Boaz Yahav [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 12:02 PM To: Chris Payne; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Theory help needed why not use one of the existing forum software? phorum? FUDForum? Sincerely berber Visit http://www.weberdev.com/ Today!!! To see where PHP might take you tomorrow. -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 6:24 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Theory help needed Hi there everyone, I have a messageboard which works, but what I need is some kind of threading for it. Right now I have EXTREMELY basic threading, where you can reply to a message, reply to replies etc . and they'll appear in the correct part of the messageboard. What I need though is to be able to do proper threading, where each reply appears under the original message and not all over the place, but i'm confused as hell. Anyway have any experience with this kind of thing and can give me a push in the right direction? I know I need to store the original ID, the forum ID, the message ID of the current message and the ID it relates to, but it's getting confusing :-) Thanks. Chris -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Theory help needed
Hi there everyone, I have a messageboard which works, but what I need is some kind of threading for it. Right now I have EXTREMELY basic threading, where you can reply to a message, reply to replies etc . and they'll appear in the correct part of the messageboard. What I need though is to be able to do proper threading, where each reply appears under the original message and not all over the place, but i'm confused as hell. Anyway have any experience with this kind of thing and can give me a push in the right direction? I know I need to store the original ID, the forum ID, the message ID of the current message and the ID it relates to, but it's getting confusing :-) Thanks. Chris