I know that it a simple task to create tables in mysql, but I want to make sure my script it correct. I am creating a "online student portfolio" as a fun project. If you have any help or suggestions please PM me or reply. Is this code right?
<?php
//this will create the student database
mysql_query("CREATE TABLE students(
id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id),
first_name VARCHAR(30),
last_name VARCHAR(30),
email VARCHAR(40),
date datetime NOT NULL default '0000-00-00 00:00:00',
grade_level INT)")
or die(mysql_error());
echo "Table Created!";
?>
