<?php
function opendatabase()
{
$hostname = "localhost";
$username = "beeseven";
$password = "**REMOVED**";
$database = "beeseven_**REMOVED**";
mysql_connect($hostname,$username,$password) or die("Could not connect to database");
mysql_select_db($database) or die("Could not select to database");
}
?>

//variables and whatnot
include 'opendatabase.php';
opendatabase();
$mysql_query = mysql_query("INSERT INTO users (name, password, concode, confirmed, email, joined, job, level, exp, moves, weapon) VALUES ($name, $password, $concode, $confirmed, $email, $joined, $job, $level, $exp, $moves, $weapon)"); //here's where my problem is
if($mysql_query === false) //this checks if the username is taken
{
 $err = mysql_errno();
 if($err == 1062) //1062 is the duplicate entry for unique field error
 {
  echo "<div class=\"err\">Error: Username taken.</div>";
  die("</body></html>");
 }
}
mysql_close();