PHP Login MD5 Encrypty.

<?php
					if($_POST){
						$host="localhost"; // Host name
						$username="root"; // Mysql username
						$password=""; // Mysql password
						$db_name="GangsterDay"; // Database name
						// Connect to server and select databse.
						mysql_connect("$host", "$username", "$password")or die("cannot connect");
						mysql_select_db("$db_name")or die("cannot select DB");

						// username and password sent from form
						$username = $_POST['user'];
						$password = md5($_POST['pass']);
						
						$username = stripslashes($username);
						$password = stripslashes($password);
						$username = mysql_real_escape_string($username);
						$password = mysql_real_escape_string($password);

						$sql="SELECT * FROM users WHERE name='$username' and password='$password'";
						$namecheck = mysql_query("SELECT name FROM users WHERE name='$username'");
						$nameexist = mysql_num_rows($namecheck);
						$result=mysql_query($sql);
						$count=mysql_num_rows($result);
						if($count==1){
							session_register("username");
							session_register("password");
							header("location: login_success.php");
						} else {
							echo 'Foute naam of Wachtwoord.';
						}
					} else {
						echo '<form action="?page=login" method="POST">
								<br><p>Gebruikersnaam: <input type="textbox" name="user" class="username" />
								<br>Wachtwoord: <input type="password" name="pass" class="password" />
								<br><input type="submit" value="Login "></p>
							  </form>';
					}
				?>

<?php
	if($_POST){
	//Define!
	define('MYSQL_HOST', 'localhost');
	define('MYSQL_USER', 'root');
	define('MYSQL_PASS', '');
	define('MYSQL_DB', 'GangsterDay');
	
	//Variable's
	$conn = @mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASS);
	$select = @mysql_select_db(MYSQL_DB);
	$email = $_POST['email'];    
	$username = $_POST['user'];
	$password = md5($_POST['pass']);
	$vpassword = md5($_POST['subpass']);
	$usercheck = mysql_query("SELECT name FROM users WHERE name='$username'");
	$userexist = mysql_num_rows($usercheck);
	$emailcheck = mysql_query("SELECT email FROM users WHERE email='$email'");
	$emailexist = mysql_num_rows($emailcheck);
	$ipcheck = mysql_query("SELECT ip FROM users WHERE ip='$ip'");
	$ipexist = mysql_num_rows($ipcheck);
	$ip = $_SERVER['REMOTE_ADDR'];
    $query = "INSERT INTO users (name, password, email, active, money, ip)
								VALUES('$username', '$vpassword', '$email', '0', '10000', '$ip')";

	//Query controle.
	if($query){
	//IP Controle of de gebruiker all een account heeft.
		if(!$ipexist == 0){
			echo '<center style="color: white;">Je hebt all een account op, GangsterDay.
					<br>Gelieven op je ander account in te loggen.</center>';
			exit;
		}
	//Als De gebruikersnaam all bestaat.
		if(!$userexist == 0){
			echo '<center style="color: white;">Gebruiker Bestaat all. 
				   <br>Gelieven een andere gebruikersnaam te nemen.</center>';
					unset($username);
					exit;
		}
	//Als de Wachtwoorden Niet Gelijk zijn.
		if($password !== $vpassword){
			echo '<center style="color: white;">Wachtwoorden niet gelijk.
				  <br><a href="javascript:history.go(-1)">Ga terug</a> en vul de juiste wachtwoorden in.</center>';
					unset($password);
					unset($vpassword);
					exit;
		}
	//Als het email adres all in gebruik is.
		if(!$emailexist == 0){
			echo '<center style="color: white;">Uw email adres is all in gebruik.
				<br>Gelieven een andere mail te gebruiken.</center>';
			exit;
		}
		mysql_query($query) or die(mysql_error());
		mysql_close();
		echo '<center style="color: white;">U bent nu geregistreerd.</center>';
	} else {
		echo mysql_error();
	}
	} else {
		echo '<center><form action="?page=register" method="POST">
			<br><p>Gebruikersnaam: <input type="textbox" name="user" class="username" />
			<br>Wachtwoord: <input type="password" name="pass" class="password" />
			<br>Bevestig Wachtwoord: <input type="password" name="subpass" class="bepassword" />
			<br>Emailadress <input type="textbox" name="email" class="email"/>
			<br><input type="submit" value="Registreren "><input type="reset" value="Reset de Text">
	</form>
	<br>
	<br>
		<img src="images/1/advert_001.png" align="center"/>
	</p></center>';
} ?>