Menu
Hi All,
I have this php script running fine but when it comes to creating tables it only creates the first table instead of 4…. why?
am I missing something here????
help is appreciated.-.-.-.-
PHP
[code]
<?php
$link = mysql_connect(‘localhost’, ‘username’, ‘password’);
if (!$link) {
die(‘Could not connect: ‘ . mysql_error());
}
$sql = ‘CREATE DATABASE test2’;
if (mysql_query($sql, $link)) {
echo “Database test2 created successfullyn”;
} else {
echo ‘Error creating database: ‘ . mysql_error() . “n”;
}
// Create tables in test2 database
mysql_select_db(“test2”, $link);
$sql = “CREATE TABLE car (
title varchar(255) NOT NULL,
description varchar(255) NOT NULL,
priority tinyint(2) NOT NULL default ‘0’
) TYPE=InnoDBn”;
mysql_query($sql, $link);
if (mysql_error()) echo __line__.”) Error creating table: “.mysql_error();
//Create links table
$sql = “CREATE TABLE links (
type varchar(20) NOT NULL default ”,
resource varchar(255) NOT NULL,
) TYPE=InnoDBn”;
mysql_query($sql, $link);
if (mysql_error()) echo __line__.”) Error creating table: “.mysql_error();
//Create home table
$sql = “CREATE TABLE home (
name varchar(255) NOT NULL,
title varchar(255) NOT NULL default ”,
description varchar(255) NOT NULL default ”,
) TYPE=InnoDBn”;
mysql_query($sql, $link);
if (mysql_error()) echo __line__.”) Error creating table: “.mysql_error();
//Create people table
$sql = “CREATE TABLE people (
name varchar(20) NOT NULL default ”,
address varchar(255) NOT NULL
resource varchar(255) NOT NULL,
) TYPE=InnoDBn”;
echo “car,home,links, & people tables in the relational database (“.test2.”) have been successfully created!n”;
mysql_query($sql, $link);
if (mysql_error()) echo __line__.”) Error creating table: “.mysql_error();
mysql_close($link);//Close connection
?>