Re: Help with MySQL script

U can also do this: $link=mysql_connect("localhost",$usr,$pwd); if (!$link) { echo("ERROR: " . mysql_error() . "); On Tue, 25 Jul 2000 wyonker@dcs.penguinpowered.com wrote: > <?php > require('common.inc'); > ?> > > <?php > $link = mysql_connect ($server, $username, > $password); > if($link == '1') > { > print ("Connected to database.<br>"); > $result = mysql_db_query ($database , > "CREATE TABLE Customers( > CustomerID INT(10) unsigned NOT NULL > DEFAULT 0 AUTO_INCREMENT, > PRIMARY KEY(CustomerID), > First varchar(30) NULL DEFAULT NULL, > Mid char(1) NULL DEFAULT NULL, > Last varchar(40) NULL DEFAULT NULL, > Address varchar(255) NULL DEFAULT NULL, > Telephone varchar(16) NULL DEFAULT NULL, > Fax varchar(16) NULL DEFAULT NULL, > Email varchar(100) NULL DEFAULT NULL, > City varchar(50) NULL DEFAULT NULL, > State char(2) NULL DEFAULT NULL, > Zip varchar(10) NULL DEFAULT NULL, > Status varchar(20) NULL DEFAULT NULL, > UNIQUE id (CustomerID))"); > if($result == '1') > { > print("Customers table created.<br>"); > } > $result = mysql_db_query ($database , > "CREATE TABLE Invoices( > InvoiceID int(10) unsigned NOT NULL > DEFAULT 0 AUTO_INCREMENT, > PRIMARY KEY(InvoiceID), > UNIQUE InvoiceID (InvoiceID), > CustomerID int(10) unsigned NOT NULL > DEFAULT 0, > Description varchar(100) NULL DEFAULT NULL, > DateBilled date NULL DEFAULT NULL, > Amount float(5,2) NULL DEFAULT NULL)"); > if($result == '1') > { > print("Invoices table created.<br>"); > } > $result = mysql_db_query ($database , > "CREATE TABLE Payments( > PaymentID int(10) unsigned NOT NULL > DEFAULT 0 AUTO_INCREMENT, > PRIMARY KEY(PaymentID), > UNIQUE PaymentID (PaymentID), > CustomerID int(10) unsigned NOT NULL > DEFAULT 0, > DatePaid date NULL DEFAULT NULL, > Type varchar(10) NULL DEFAULT NULL, > Number varchar(50) NULL DEFAULT NULL, > Amount float(5,2) NULL DEFAULT NULL)"); > if($result == '1') > { > print("Payments table created.<br>"); > } > $result = mysql_db_query ($database , > "CREATE TABLE Tickets( > TicketID int(10) unsigned NOT NULL > DEFAULT 0 AUTO_INCREMENT, > PRIMARY KEY(TicketID), > UNIQUE TicketID (TicketID), > CustomerID int(10) unsigned NOT NULL > DEFAULT 0, > Description varchar(100) NULL DEFAULT > NULL, > Status varchar(10) NULL DEFALUT NULL, > OpenDate date NULL DEFAULT NULL, > OpenTime time NULL DEFAULT NULL, > CloseDate date NULL DEFAULT NULL, > CloseTime time NULL DEFAULT NULL, > Opener varchar(100) NULL DEFAULT > NULL)"); > if($result == '1') > { > print("Tickets table created.<br>"); > } > else > { > print($result); > } > $result = mysql_db_query ($database , > "CREATE TABLE Rollback( > RollbackID int(10) unsigned NOT NULL > DEFAULT 0 AUTO_INCREMENT, > PRIMARY KEY(RollbackID), > Description varchar(100) NULL DEFAULT > NULL, > RestoreStatement blob NULL DEFAULT NULL, > When datetime NULL DEFAULT NULL)"); > if($result == '1') > { > print("Rollback table created.<br>"); > } > $result = mysql_db_query ($database , > "CREATE TABLE Accounts( > AccountID int(10) unsigned NOT NULL > DEFAULT 0 AUTO_INCREMENT, > PRIMARY KEY(AccountID), > UNIQUE AccountID (AccountID), > CustomerID int(10) unsigned, > Username varchar(50), > Password varchar(50), > Description varhcar(100), > DateOpened date, > DateClosed date, > Price float(5,2), > Status varchar(25), > Charged varchar(15) DEFAULT '' NOT NULL)"); > if($result == '1') > { > print("Accounts table created.<br>"); > } > $result = mysql_db_query ($database , > "CREATE TABLE Configuration( > Version varchar(50), > BillAhead enum('On','Off'), > Language varchar(50))"); > if($result == '1') > { > print("Configuration table > created.<br>"); > } > } > else > { > print("Unable to connect to database. > <br><br>Exiting.<br>"); > } > ?> > > > There is the script. It does not create the > Tickets or Accounts tables. I have no idea why. > Can someone enlighten me? > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >