Would This Work?

[calumrouge]

My Hosting is down. Could someone please tell me if the following will work:

[font=Courier New][b]<?php
$conn = mysql_connect("localhost","missionxgame_admin","PRIVATE");
if (!$conn)
  {
  die('Could not connect: ' . mysql_error());
  }
 
  if (mysql_query("CREATE DATABASE missionxgame_gamedb",$conn))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }
 
  mysql_select_db("missionxgame_gamedb", $conn);
$sql = "CREATE TABLE Users
(
Person-ID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(personID),
Username varchar(15),
Password varchar(20),
E-mail varchar(100),
)";
mysql_query($sql,$conn);

mysql_select_db("missionxgame_gamedb", $conn);
mysql_query("INSERT INTO Users (Username,Password,E-mail)
VALUES ('Admin', 'PRIVATE', 'calumrouge-uk@hotmail.co.uk')");
?>[/b][/font]

[HuggieBear]

It looks OK, so long as the user you connect to the server with has the correct permissions.

Regards
Huggie

[Psycho]

[quote author=calumrouge link=topic=117284.msg478358#msg478358 date=1165233959]
My Hosting is down. Could someone please tell me if the following will work[/quote]

You should download XAMPP or some other local development environment. It will make your life much easier.