<?php

function createdb()
{
    $host="localhost";
    $username="root";
    $password="";
    $db_name="db_guestbook";
    $tbl_data="tbl_data";
    $tbl_admins="tbl_admins";

    $con = mysql_connect("$host", "$username", "$password");
    if(!$con) die(mysql_error());
    if(mysql_query("CREATE DATABASE $db_name",$con))
    {
        $select = mysql_select_db("$db_name", $con);
        if($select)
        {
            $sql = "CREATE TABLE $tbl_data
            (
            ID int NOT NULL AUTO_INCREMENT,
            PRIMARY KEY(ID),
            Name varchar(50),
            Email varchar(50),
            Comment varchar(50),
            Datetime datetime
            )";
            mysql_query($sql, $con);

            $sql = "CREATE TABLE $tbl_admins
            (
            ID int NOT NULL AUTO_INCREMENT,
            PRIMARY KEY(ID),
            Username varchar(50),
            Password varchar(50),
            )";
            mysql_query($sql, $con);
        }
        else
        {
            die(mysql_error());
        }

    }
    else
    {
        die(mysql_error());
    }
}

?>