Jump to content

Creating mysql DB with php


big-dog1965

Recommended Posts

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);

?>

Link to comment
https://forums.phpfreaks.com/topic/82615-creating-mysql-db-with-php/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.