Ask Experts Questions for FREE Help !
    Scotty13's Avatar
    Scotty13 Posts: 120, Reputation: 1
    Junior Member

    Oct 27, 2011, 10:21 AM
    I canât create a table through 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,
    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

    What 'am I missing?

    Thanks, Scotty

Check out some similar questions!

CSS Layouts in Dreamweaver CS4 Missing Files [ 1 Answers ]

Somehow the css files that came with the DW CS4 layouts have either disappeared from my computer, or have somehow become disassociated. The result is that I cannot create a new page using one of the provided CS4 layouts Does anyone have an idea how to get them back?

Execute immediate 'create table' in script [ 3 Answers ]

My oracle version is In Toad I have no problem 1) to create table trg_farinvc as select 2) select * from all_objects where object_name like 'TRG_FARINVC%' 3) drop table TRG_FARINVC PURGE 3) create table trg_farinvc as select --> create table again no problem. 4) drop table...

Which table to create main form [ 3 Answers ]

I have created the following tables per a response from Scottgem at to another user asking about creating a Access Database for a survey. My database has 26 questions with answers range being not very true to verry true with a couple simple yes no answers. Where I am stumped is how to display...

View more questions Search

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.