Jump to content

Can’t create an emailSystem table in DW CS4


Scotty13

Recommended Posts

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

Link to comment
Share on other sites

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...