Jump to content


Can’t create an emailSystem table in DW CS4

  • Please log in to reply
No replies to this topic

#1 Scotty13



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

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,
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

What ‘am I missing?

Thanks, Scotty
  • 0

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users