Scotty13 Posted October 27, 2011 Report Share Posted October 27, 2011 I’m trying to create a table thru Dreamweaver CS4 titled emailSystem. 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.