//Database Structute
		//Setting username and password
		$username = '';
		$password = '';
		$database = "scotlandbands";
		
	//MySQL Connections
	mysql_connect($localhost, $username, $password) or die ('<strong>MySQL Error:</strong>'.mysql_error());
	mysql_select_db($database) or die ('<strong>MySQL Error:</strong>'.mysql_error());
	
	//setting variables 
	$reg_username = addslashes($_POST['reg_username']);
	$reg_email = addslashes($_POST['reg_email']);
	$reg_password = md5($_POST['reg_password']);
	
	//creating a query that inserts the data into the database
	$query = 'INSERT INTO users SET

          user_name = "'.mysql_real_escape_string($reg_username).'",
          email = "'.mysql_real_escape_string($reg_email).'",
          user_pass = "'.mysql_real_escape_string($reg_password).'"';
	
	//execcute a query on a MySQL database
	mysql_query($query);
	
	//close database connection
	mysql_close();