Log in

View Full Version : I can’t create a table through Dreamweaver CS4 titled emailSystem


Scotty13
Oct 27, 2011, 10:21 AM
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