<?php

	$con=mysql_connect("localhost","user","pass");

	mysql_select_db("db");

	$username=mysql_real_escape_string($_POST['username']);
	$password=mysql_real_escape_string($_POST['password']);
	$confirm_password=mysql_real_escape_string($_POST['password2']);
	$email=mysql_real_escape_string($_POST['email']);

	$queryuser=mysql_query("SELECT * FROM users WHERE username='$username' ");
	$checkuser=mysql_num_rows($queryuser);

	$queryuemail=mysql_query("SELECT * FROM users WHERE email='$email' ");
	$checkemail=mysql_num_rows($queryemail);

		if($checkuser != 0) {
			echo "Username already in use, please go back and try again.";
		} if($checkemail != 0) {
			echo "Email address already in use, please go back and try again.";
		} if($password != $confirm_password) {
			echo "The passwords did not match, please go back and try again.";
		} else {
			$query='"INSERT INTO users (username, password, email) VALUES ("$username", "md5($password)", "$email")"';
			mysql_query($query);

			echo 'Registration complete, you may now login.';
		}

	mysql_close($con);
?>