Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Dreamweaver (https://www.askmehelpdesk.com/forumdisplay.php?f=470)
-   -   I can’t create a table through Dreamweaver CS4 titled emailSystem (https://www.askmehelpdesk.com/showthread.php?t=607287)

  • Oct 27, 2011, 10:21 AM
    Scotty13
    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

  • All times are GMT -7. The time now is 11:58 AM.