PHP Code:
<?php
$dbhost = '';
$dbuser = '';
$dbpass = '';
$dbname = '';
$con = mysql_connect($dbhost, $dbuser,$dbpass);
if (!$con)
{
die('Error Connecting To Database' . mydwl_error());
}
$datab = mysql_select_db($dbname,$con);
if (!$datab)
{
die('Error Connecting To Database' . mysql_error());
}
$sqltable = "CREATE TABLE users (
UserID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
UserName varchar(15),
PassWord varchar(15),
Email varchar,
KeyCode varchar(20),
Validated enum('TRUE','FALSE'),
MainLang varchar,
RegeDate datetime NOT NULL,
LastDate datetime NOT NULL,
RecQues varchar,
RecAns varchar,
AcStat enum('Member','Moderator','Administrator','Banned','Frozen','Blocked'),
Level enum('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20'),
UserRank varchar
)";
echo $sqltable; //just testing
mysql_query($sqltable,$con);
mysql_close($con);
?>