big-dog1965 Posted December 21, 2007 Share Posted December 21, 2007 Can some one see what is wrong with this when I run it in browser it simple does nothing that I can tell. dont creat table or display error either <?php include("access.inc.php"); $conn = mysql_connect(localhost,$username,$password); $query = 'CREATE TABLE `Series`.`SAMPLE` ( `id` int( 10 ) unsigned NOT NULL auto_increment , `Name` text NOT NULL , `Address` text NOT NULL , `Apt` text NOT NULL , `City` text NOT NULL , `State` text NOT NULL , `ZipCode` text NOT NULL , `Phone` text NOT NULL , `E_Mail` text NOT NULL , `Eighth_Scale_Buggy` text NOT NULL , `Frequency_1_Buggy` text NOT NULL , `Frequency_2_Buggy` text NOT NULL , `Transponder_Buggy` text NOT NULL , `Skill_Level_Buggy` text NOT NULL , `Eighth_Scale_Sportsman` text NOT NULL , `Frequency_1_Sportsman` text NOT NULL , `Frequency_2_Sportsman` text NOT NULL , `Transponder_Sportsman` text NOT NULL , `Skill_Level_Sportsman` text NOT NULL , `Arena_Truck` text NOT NULL , `Frequency_1_Arena_Truck` text NOT NULL , `Frequency_2_Arena_Truck` text NOT NULL , `Transponder_Arena_Truck` text NOT NULL , `Skill_Level_Arena_Truck` text NOT NULL , `Monster_Truck` text NOT NULL , `Frequency_1_Monster_Truck` text NOT NULL , `Frequency_2_Monster_Truck` text NOT NULL , `Transponder_Monster_Truck` text NOT NULL , `Skill_Level_Monster_Truck` text NOT NULL , `Stadium_Truck` text NOT NULL , `Frequency_1_Stadium_Truck` text NOT NULL , `Frequency_2_Stadium_Truck` text NOT NULL , `Transponder_Stadium_Truck` text NOT NULL , `Skill_Level_Stadium_Truck` text NOT NULL , `Comments` text NOT NULL , `Attend_Round` text NOT NULL , `Agree_To_Terms` text NOT NULL , `Track_Name` text NOT NULL , `Track_Contact` text NOT NULL , `Track_Address` text NOT NULL , `Track_City` text NOT NULL , `Track_State` text NOT NULL , `Track_ZipCode` text NOT NULL , `Track_Phone` text NOT NULL , `Track__EMail` text NOT NULL , `Track_WebSite` text NOT NULL , `IP_Address` text NOT NULL , `Date_Posted` text NOT NULL , PRIMARY KEY ( `id` ) , UNIQUE KEY `id_2` ( `id` ) , KEY `id` ( `id` ) ) ENGINE = MyISAM DEFAULT CHARSET = latin1 COMMENT = \'Created by Kelly\' '; mysql_query($query); ?> Quote Link to comment https://forums.phpfreaks.com/topic/82615-creating-mysql-db-with-php/ Share on other sites More sharing options...
CMC Posted December 21, 2007 Share Posted December 21, 2007 Well you haven't set it to display anything, and since it's displaying nothing, I'd assume it worked. Quote Link to comment https://forums.phpfreaks.com/topic/82615-creating-mysql-db-with-php/#findComment-420165 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.