s

CREATE TABLE `forums` (
  `id` int(3) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3;

INSERT INTO `forums` (`id`, `name`) VALUES
(1, 'Test Forum'),


CREATE TABLE `members` (
  `id` int(4) NOT NULL auto_increment,
  `username` varchar(65) NOT NULL default '',
  `password` varchar(65) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3;


CREATE TABLE `replies` (
  `topicid` int(4) NOT NULL,
  `reply_id` int(4) NOT NULL,
  `reply_user` varchar(50) NOT NULL,
  `reply_text` longtext NOT NULL,
  `reply_datetime` varchar(25) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE `topics` (
  `id` tinyint(4) NOT NULL auto_increment,
  `title` varchar(180) NOT NULL,
  `text` longtext NOT NULL,
  `datetime` varchar(30) NOT NULL default '0',
  `user` varchar(80) NOT NULL,
  `reply` int(4) NOT NULL,
  `forumid` int(3) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6;

<?php

$host=    "[b]localhost[/b]"; // Host name
$username="[b]admin[/b]"; // Mysql username
$password="[b]adminone[/b]"; // Mysql password
$db_name= "[b]admindb[/b]"; // Database name


mysql_connect("$host", "$username", "$password")or die("Failed to connect to DB server");
mysql_select_db("$db_name")or die("Failed to select DB");
?>

<?php
$name =  $_COOKIE['username_cb'];
if ( $name == "" ) {
$name="Guest";
}
//---------------------------------------------------------
// Include all necessary files and find the requested page
//---------------------------------------------------------
include "conf.php";
//---------------------------------------------------------
// Prepare a few things
//---------------------------------------------------------
$page = $_GET['p'];
  if ($page=="")
{
$page = main;
}
switch ($page) {
//---------------------------------------------------------
// Show the list of forums
//---------------------------------------------------------
case "showforums":

echo "<table width=\"90%\" border=\"0\" align=\"center\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=\"#CCCCCC\">
<tr>
<td width=\"6%\" align=\"center\" bgcolor=\"#E6E6E6\"><strong>#</strong></td>
<td width=\"76%\" align=\"center\" bgcolor=\"#E6E6E6\"><strong>Forum</strong></td>
<td width=\"18%\" align=\"center\" bgcolor=\"#E6E6E6\"><strong>Last Topic</strong></td>
</tr> ";

$sql="SELECT * FROM forums ORDER BY id ASC";
// Now to get the forums list done
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){
echo "
<tr>
<td bgcolor=\"#FFFFFF\">".$rows['id']."</td>
<td align=\"left\" valign = \"top\" bgcolor=\"#FFFFFF\"><B><a href=\"index.php?p=showtopics&id=". $rows['id'] ."\">". $rows['name'] ."</a></b><BR>". $rows['desc'] ."</td>
<td bgcolor=\"#FFFFFF\">".$rows['lastpost']."</td>";
}
//Join it all up
echo "</table>";
break;
}
?>