Tie mysql database to my website

[yassine chafik]

Hi, I'm trying to make it so that my website register accounts on my world of warcraft server but it just won't create accounts, I don't understand what I'm doing wrong, here's the code


<?
$dbhost = "50.101.185.87";
$dbuser = "root";
$dbpass = "ascent";
$dbname = "auth";

// CREATED NY MIKEAMBROSE3 DO NOT EDIT BELOW THIS!!!!
$db = mysql_pconnect($dbhost,$dbuser,$dbpass);
mysql_select_db("$dbname",$db);

$fetchh = mysql_query("SELECT * FROM accounts WHERE email='{$_POST["register"]["email"]}'")or
die(mysql_error());

$numm = mysql_num_rows($fetchh);

if (!empty($num))
die('This email already exists, Please select a new one.');

$fetch = mysql_query("SELECT * FROM accounts WHERE login='{$_POST["register"]["name"]}'")or
die(mysql_error());

$num = mysql_num_rows($fetch);

if (!empty($num))
die('This account exists, Please select a new one.');

mysql_query("INSERT INTO `accounts` (`login`, `password`, `email`) VALUES ('{$_POST["register"]["name"]}', '{$_POST["register"]["pass"]}', '{$_POST["register"]["mail"]}')");
?>

Your account has been created.<br>