I am having a problem creating tables with the following code. The database is created fine but none of the tables show in MySQL. Please advice as to what I am doing wrong. Thank you!
<?php
$database = $_POST['database'];
// 1. Create a database connection
$connection = mysql_connect("xx", "xx", "xx");
if (!$connection) {
die("Database connection failed: " . mysql_error());
}
// 2. Select a database to use
$db_select = mysql_select_db($database, $connection);
// 3. Perform database query
$result = mysql_query("SELECT * FROM accounts", $connection);
if ($result) {
echo "Database '$database' already exists.";
} else {
echo "No database found.<br>";
$query = ("CREATE DATABASE $database");
$result = mysql_query($query);
mysql_select_db("$database") or die("Unable to create new database: $database <br>");
echo "Database '$database' was created.<br>";
//create data tables
$query = 'CREATE TABLE accounts( '.
'account_id INT NOT NULL AUTO_INCREMENT, '.
'account_name VARCHAR(50) NOT NULL, '.
'account_street VARCHAR(50) NOT NULL, '.
'account_city VARCHAR(30) NOT NULL, '.
'account_state VARCHAR(30) NOT NULL, '.
'account_zipcode INT(15) NOT NULL, '.
'account_phone VARCHAR(30) NOT NULL, '.
'contact_firstname VARCHAR(30) NOT NULL, '.
'contact_lastname VARCHAR(30) NOT NULL, '.
'contact_phone VARCHAR(30) NOT NULL, '.
'contact_fax VARCHAR(30), '.
'contact_email VARCHAR(30) NOT NULL, '.
'PRIMARY KEY(id))';
$result = mysql_query($query);
if ($result) { echo "Table 'accounts' was created successfully.<br>"; }
$query = 'CREATE TABLE reports( '.
'report_id INT NOT NULL AUTO_INCREMENT, '.
'report_type VARCHAR(10) NOT NULL, '.
'report_status VARCHAR(30) NOT NULL, '.
'report_message VARCHAR(30) NOT NULL, '.
'PRIMARY KEY(id))';
$result = mysql_query($query);
if ($result) { echo "Table 'reports' was created successfully.<br>"; }
}
?>
