FW: hello ... best schema to a forum
| From: | José Moreira | Date: | Wed, 29 May 2002 16:39:30 +0000 |
| Subject: | FW: hello ... best schema to a forum | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19497@lists.php.net to get a copy of this message | ||
-----Mensagem original-----
De: José Moreira [mailto:jmoreira@e-terno.net]
Enviada: terça-feira, 28 de Maio de 2002 15:14
Para: php-db@lists.php.net
Assunto: FW: hello ... best schema to a forum
Importância: Alta
im trying to figure out the best mySQL schema to create a forum on my
website ... to result in a tree-view style presentation
what i have right now is a 3 table schema : categories > sub-categories >
lines ... wich would result in a code parsing to emulate the tree
the other way is a nodes->leaf schema that whould envolve recursive
programming ...
the result i wouuld want is something like, ex.
º main
º programming
º php
whats your opinion ?
my regards,
josé moreira
portugal