Scotty13 Posted May 9, 2012 Share Posted May 9, 2012 Trying to get my main table to connect. Keeping getting the same error…Success in database CONNECTION.....no TABLE created. You have problems in the system already, backtrack and debug!My table in my script/ Dreamweaver CS 4 matches exactly to entries I have in phpMyAdmin. What ‘am I missing here?<?php require_once "connect_to_mysql.php"; // Tell ourselves on screen if we have connected print "Success in database CONNECTION.....<br />"; // Create the members main table in your new database $result = "CREATE TABLE myMembers ( id int(11) NOT NULL auto_increment, uid int(11) NOT NULL, username varchar(255) NOT NULL, firstname varchar(255) NOT NULL lastname varchar(255) NOT NULL, maidenname varchar(255) NULL, city varchar(255) NOT NULL, state_province varchar(255) NOT NULL, country varchar(255) NOT NULL, workstatus varchar(255) NOT NULL, seniority date NOT NULL default '0000-00-00' airline varchar(255) NOT NULL, currentairline varchar(255) NOT NULL, previousairline varchar(255) NOT NULL, myfirstairline varchar(255) NOT NULL, email varchar(255) NOT NULL, locator varchar(255) NOT NULL, made_res_date datetime NOT NULL default '0000-00-00', last_ckin_date datetime NOT NULL default '0000-00-00', bio_body text NULL, website varchar(255) NULL, ipaddress varchar(255) NOT NULL, passenger_array text NULL, ts timestamp NULL default '0000-00-00 00:00:00', account_type enum('a','b','c') NOT NULL default 'a', email_activated enum('0','1') NOT NULL default '0', private enum('0','1') NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY email (email) ) "; if (mysql_query($result)){ print "Success in TABLE creation!...... <br /><br /><b>That completes the table setup, now delete the file <br /> named 'create_Table.php' and you are ready to move on. Let us go!</b>"; } else { print "no TABLE created. You have problems in the system already, backtrack and debug!"; } exit(); ?>Thanks, Scott Link to comment Share on other sites More sharing options...
justsomeguy Posted May 9, 2012 Share Posted May 9, 2012 Is the table already there? If not, add some error checking when you run the query. } else { print "no TABLE created. You have problems in the system already, backtrack and debug!<br>"; echo mysql_error(); } Link to comment Share on other sites More sharing options...
Scotty13 Posted May 10, 2012 Author Share Posted May 10, 2012 Response... Success in database CONNECTION.....no TABLE created. You have problems in the system already, backtrack and debug! Table 'myMembers' already exists. Already exists, so I'm good? Link to comment Share on other sites More sharing options...
birbal Posted May 10, 2012 Share Posted May 10, 2012 You cant have same table name in a database either change the table name which you are creating or drop the previous one. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now