I build 14 others with no problem. Here is what I have…
<?php
require_once “connect_to_mysql.php”;
print “Success in database CONNECTION…<br />”;
$tableCreate = “CREATE TABLE emailSystem (
mid int(11) NOT NULL auto_increment,
date date NOT NULL,
sender varchar(255) NOT NULL,
receiver varchar(255) NOT NULL,
title varchar(255) NOT NULL,
announcements longtext NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY email (email)
)”;
// This line uses the mysql_query() function to create the table now
$queryResult = mysql_query($tableCreate);
// Create a conditional to see if the query executed successfully or not
if ($queryResult === TRUE) {
print “<br /><br />Success in TABLE creation! Happy Coding!”;
} else {
print “<br /><br />No TABLE created. Check”;
}
// close mysql connection
mysql_close();
?>
What ‘am I missing?
Thanks, Scotty
