PHP Code:
<?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);
?>
Bookmarks