<?php

	$con=mysql_connect("myhost","myuser","mypass");

	mysql_select_db("mydb");

	$username=$_POST['username'];
	$password=$_POST['password'];
	$confirm_password=$_POST['password2'];
	$email=$_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")"';
			$q2= mysql_real_escape_string($query);
			mysql_query($q2);

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

	mysql_close($con);
?>