Untitled

<html><body>
<?

//Database config
$db_server =    'localhost';
$db_user =      'username';
$db_pass =      'password';
$db_database =  'dbname';

$con = mysql_connect("$db_server","$db_user","$db_pass");
if (!$con)
        {
        die('could not connect: ' . mysql_error());
        }

if (mysql_query("CREATE DATABASE $db_database",$con))
  {
  echo "Database created</br />";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }

mysql_select_db("$db_database", $con);
$sql = "CREATE TABLE song
(
songID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(songID),
song_name varchar(140)
)";

mysql_query("INSERT INTO song (song_name)
VALUES ('Random song')");

mysql_query($sql,$con);

echo 'All's good, your database is setup. You can start the script.';

?>

</body></html>