Code: Select all
<?php
function dbcreate()
{
include config.php();
$host = $set['dbhost']
$uname = $set['dbuname']
$pass = $set['dbpass']
$dbcn = @mysql_connect($host, $uname, $pass) or die("Could not connect: " . mysql_error());
$select = mysql_select_db("CMS");
$create = "CREATE TABLE test (
id int NOT NULL AUTO_INCREMENT,
firstname varchar(25),
lastname varchar(20),
nick varchar(12),
email varchar(35),
salary int,
PRIMARY KEY (id),
UNIQUE id (id)
);";
$result = mysql_query($create);
echo mysql_errno() . ": " . mysql_error() . "\n";
echo "Table created";
}
?>cheers guys.
LinkJames