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

    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…

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

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 10.2.0.3.0. 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.