$sql = "CREATE TABLE users (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
pref1 VARCHAR(30),
pref2 VARCHAR(30),
pref3 VARCHAR(30),
reg_date TIMESTAMP )";
if (mysqli_query($conn, $sql)) {
 echo "Table users created successfully";
} else {
 echo "Error creating table: " . mysqli_error($conn);
}
mysqli_close($conn);
?>