[RESOLVED] creating a mysql table with php

[big-dog]

How do I make this creat the table in mysql by running the php file.

<?php
 CREATE  TABLE  `wichita_frgn1`.`Registrations` (  `id` int( 10  )  unsigned NOT  NULL  auto_increment ,
 `First_Name` text NOT  NULL ,
 `Last_Name` text NOT  NULL ,
 `Address` text NOT  NULL ,
 `City` text NOT  NULL ,
 `State` text NOT  NULL ,
 `Zip_Code` text NOT  NULL ,
 `Home_Phone` text NOT  NULL ,
 `Cell_Phone` text NOT  NULL ,
 `E_Mail` text NOT  NULL ,
 `Membership_No` text NOT  NULL ,
 `Roar_No` text NOT  NULL ,
 `First_Class` text NOT  NULL ,
 `Transmitter_Frequency` text NOT  NULL ,
 `Transponder_No` text NOT  NULL ,
 `Track_Transponder` text NOT  NULL ,
 `Second_Class` text NOT  NULL ,
 `Transmitter_Frequency2` text NOT  NULL ,
 `Transponder_No2` text NOT  NULL ,
 `Track_Transponder2` text NOT  NULL ,
 `Ability_Skill_Level` text NOT  NULL ,
 `Race_Date` date NOT  NULL default  '0000-00-00',
 `Track` 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 Big-Dog;
 ?>

[NogDog]

<?php
// edit values for host, user, and password:
mysql_connect('localhost', 'dbusername', 'dbpassword') or
      die("Unable to connect to DBMS.<br />".mysql_error());
// edit value for database name:
mysql_select_db('databasename') or 
      die("Unable to select DB<br />".mysql_error());
$sql = <<<EOD
CREATE  TABLE  `wichita_frgn1`.`Registrations` (  `id` int( 10  )  unsigned NOT  NULL  auto_increment ,
`First_Name` text NOT  NULL ,
`Last_Name` text NOT  NULL ,
`Address` text NOT  NULL ,
`City` text NOT  NULL ,
`State` text NOT  NULL ,
`Zip_Code` text NOT  NULL ,
`Home_Phone` text NOT  NULL ,
`Cell_Phone` text NOT  NULL ,
`E_Mail` text NOT  NULL ,
`Membership_No` text NOT  NULL ,
`Roar_No` text NOT  NULL ,
`First_Class` text NOT  NULL ,
`Transmitter_Frequency` text NOT  NULL ,
`Transponder_No` text NOT  NULL ,
`Track_Transponder` text NOT  NULL ,
`Second_Class` text NOT  NULL ,
`Transmitter_Frequency2` text NOT  NULL ,
`Transponder_No2` text NOT  NULL ,
`Track_Transponder2` text NOT  NULL ,
`Ability_Skill_Level` text NOT  NULL ,
`Race_Date` date NOT  NULL default  '0000-00-00',
`Track` 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 Big-Dog'
EOD;
$result = mysql_query($sql) or
      die("Query failed.<br />$sql<br />".mysql_error());
?> 

[big-dog]

I get a blank page in the browser with this and when I check mysql the table isnt created.

NogDog wrote:

<?php
// edit values for host, user, and password:
mysql_connect('localhost', 'dbusername', 'dbpassword') or
      die("Unable to connect to DBMS.<br />".mysql_error());
// edit value for database name:
mysql_select_db('databasename') or 
      die("Unable to select DB<br />".mysql_error());
$sql = <<<EOD
CREATE  TABLE  `wichita_frgn1`.`Registrations` (  `id` int( 10  )  unsigned NOT  NULL  auto_increment ,
`First_Name` text NOT  NULL ,
`Last_Name` text NOT  NULL ,
`Address` text NOT  NULL ,
`City` text NOT  NULL ,
`State` text NOT  NULL ,
`Zip_Code` text NOT  NULL ,
`Home_Phone` text NOT  NULL ,
`Cell_Phone` text NOT  NULL ,
`E_Mail` text NOT  NULL ,
`Membership_No` text NOT  NULL ,
`Roar_No` text NOT  NULL ,
`First_Class` text NOT  NULL ,
`Transmitter_Frequency` text NOT  NULL ,
`Transponder_No` text NOT  NULL ,
`Track_Transponder` text NOT  NULL ,
`Second_Class` text NOT  NULL ,
`Transmitter_Frequency2` text NOT  NULL ,
`Transponder_No2` text NOT  NULL ,
`Track_Transponder2` text NOT  NULL ,
`Ability_Skill_Level` text NOT  NULL ,
`Race_Date` date NOT  NULL default  '0000-00-00',
`Track` 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 Big-Dog'
EOD;
$result = mysql_query($sql) or
      die("Query failed.<br />$sql<br />".mysql_error());
?>