Code: Select all
$query4 = "create table job(id INT PRIMARY KEY,
username VARCHAR(30) NOT NULL,
sdate DATE NOT NULL,
edate DATE NOT NULL,
company VARCHAR(30) NOT NULL,
location VARCHAR(30) NOT NULL,
position VARCHAR(30) NOT NULL,
desc TEXT NOT NULL)";
if (mysql_query($query4))
echo "Table job is created";
else
echo "Table job can't be created, mysqlerror()";