Jump to content


Photo

Can’t create an emailSystem table in DW CS4


  • Please log in to reply
No replies to this topic

#1 Scotty13

Scotty13

    Member

  • Member
  • PipPipPip
  • 62 posts

Posted 27 October 2011 - 12:19 PM

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
  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users