Message Board

[harkly]

I want to set up a message board that is only between 2 people. I have found a simple msg board code and have been trying to modify it to fit what I want. I need a little help in figuring out what the process should be when there are multiple replies.

 

Does anyone knows where there is a sample of such a board?

 

This is what I have so far ...

 

My tables and one file, I attached the others

 

CREATE TABLE threads (id INT NOT NULL AUTO_INCREMENT ,
title VARCHAR( 255 ) NOT NULL ,
message TEXT NOT NULL ,
author VARCHAR(32) NOT NULL ,
replies INT( 11 ) NOT NULL ,
posted VARCHAR( 255 ) NOT NULL ,
status TINYINT(1) NOT NULL ,
PRIMARY KEY ( id ));

CREATE TABLE replies (id INT NOT NULL AUTO_INCREMENT ,
thread INT( 11 ) NOT NULL ,
message TEXT NOT NULL ,
author VARCHAR(32) NOT NULL ,
posted VARCHAR( 255 ) NOT NULL ,
status TINYINT(1) NOT NULL ,
PRIMARY KEY ( id ));

 

<?php
   include('library/login.php');
   login();
?>

<?php
$time = time();
mysql_query("INSERT INTO threads VALUES(NULL,'$_POST[title]','$_POST[message]','$_POST[sender]','$_POST[receiver]','0','$time','0')");

echo "Message has been sent.";
?>

 

 

If anyone could give me some direction on how to deal with the mulitple replies I would be gratefull

 

[attachment deleted by admin]