Discussionforum with PHP and MySQL

Hi there!

I´m quite new to both PHP and MySQL.
As an exercise I´m just trying to develop a news forum with PHP and MySQL. What I´m looking for is an advise of how to layout the
database.
I thought about something like this:
Key: topicID
other columns: parent (for replys), kids (for number of kids), root (for distance to root news), and some columns for name, date and so on.
Is that a good idea?
If somebody could help I´d be really happy URL

Thanks and take care everybody!

Have a look at the source for Phorum for ideas:

www.phorum.org

adam


------------------

<?php
$s = array("J","A","p","h","p","H");
for ($i = 0; $i <= 9; $i++) { echo $s[$i]; }
?> URL


[This message has been edited by dahamsta (edited 08-20-99).]