Create Mutiple Tables

[Salchester]

Heyo,

I currently have the following code to create a database + table,
how do I amend the code to create two tables inside the database?

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
  die('Could not connect: ' . mysql_error());
}
 
// Create database
if (mysql_query("CREATE DATABASE Users",$con))
{
  echo "Database created!";
}
else
{
  echo "Error creating database: " . mysql_error();
}
 
// Create table in WB database
mysql_select_db("Users", $con);
$sql = "CREATE TABLE Records 
(
  id int not null auto_increment,
  username text,
  password text,
  primary key(id)
)";
mysql_query($sql,$con);
 
mysql_close($con);
?>

[adnasium]

why don't you just use phpmyadmin and do it the easy way?

Are you writing a script that will do this for you?

[Salchester]

why don't you just use phpmyadmin and do it the easy way?

Are you writing a script that will do this for you?

Yes, the code attached to my previous post, create a database with one table, how do I create a database with two?

[adnasium]

Whats the problem with doing this?

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
  die('Could not connect: ' . mysql_error());
}
 
// Create database
if (mysql_query("CREATE DATABASE Users",$con))
{
  echo "Database created!";
}
else
{
  echo "Error creating database: " . mysql_error();
}
 
// Create table in WB database
mysql_select_db("Users", $con);
$sql = "CREATE TABLE Records
(
  id int not null auto_increment,
  username text,
  password text,
  primary key(id)
)";
mysql_query($sql,$con);

// Create table in WB database
mysql_select_db("Users", $con);
$sql = "CREATE TABLE Records
(
  id int not null auto_increment,
  username text,
  password text,
  primary key(id)
)";
mysql_query($sql,$con);
 
mysql_close($con);
?>

[adnasium]

You would just change the last part to create the table you want. All you are doing is executing a query.

[Salchester]

What last part?