<?php
$host = $_POST["host"];
$username = $_POST["uname"];
$password = $_POST["pw"];
$password2 = $_POST["pw2"];
$db= = $_POST["db"];


if($password != $password2)
    {
        echo "Passwords do no match. Please go back and try again";
    }

$con = mysql_connect($host, $username, $password);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_query(create database $db);

mysql_select_db($db, $con);

$sql = "CREATE table forum
    {
    forumid bgint(20) NOT NULL AUTO_INCREMENT,
    PRIMARY KEY(forumid),
    subject varchar(100) NOT NULL,
    name varchar(25) NOT NULL,
    message text NOT NULL,
    sorter int(20) NOT NULL,
    submitdate varchar(20) NOT NULL,
    belongstoid bgint(20) NOT NULL,
    replys int(11) NOT NULL,
    host varchar(100) NOT NULL,
    time varchar(15),
    lastreply varchar(35) NOT NULL,
    lastposter varchar(20) NOT NULL
    }";

mysql_query($sql,$con);

$sql2 = "CREATE table users
    {
    id int(11) NOT NULL.
    PRIMARY KEY(id),
    fname varchar(20),
    lname varchar(20),
    age varchar(8),
    sex varchar(6),
    location varchar(40) NULL,
    email varchar(50),
    username varchar(20),
    password varchar(100) NULL,
    updateu varchar(20),
    joindate varchar(15),
    posts int(6),
    imagename varchar(255) NOT NULL
    }";

mysql_query($sql2,$con);

mysql_close($con);

echo "Done!";

?>