# I can’t create a table thru Dreamweaver CS4 titled emailSystem

**URL:** <https://forum.kirupa.com/t/i-can-t-create-a-table-thru-dreamweaver-cs4-titled-emailsystem/325650>\
**Category:** flash\
**Created:** [October 27, 2011, 5:23pm UTC](https://forum.kirupa.com/t/i-can-t-create-a-table-thru-dreamweaver-cs4-titled-emailsystem/325650 "2011-10-27T17:23:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Scotty13](https://avatars.discourse-cdn.com/v4/letter/s/7bcc69/32.png) [@Scotty13](https://forum.kirupa.com/u/Scotty13)\
**Post date:** [October 27, 2011, 5:23pm UTC](https://forum.kirupa.com/t/i-can-t-create-a-table-thru-dreamweaver-cs4-titled-emailsystem/325650/1 "2011-10-27T17:23:51Z")

</div>

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