PHP code.

<?php

//connect

include('connect.php');

//define variables

$Firstname = $_POST['FirstName'];
$Surname = $POST['Surname'];
$EmailAddress = $POST['EmailAddress'];
$Username = $POST['Username'];
$Password = $POST['Password'];
$ConfirmPassword = $POST['ConfirmPassword'];

echo $Firstname;
echo "<br />";
echo $Surname;
echo "<br />";
echo $EmailAddress;
echo "<br />";
echo $Username;
echo "<br />";
echo $Password;
echo "<br />";
echo $ConfirmPassword;

//secure variables by sanitization.

$Firstname = (strip_tags($Firstname));
$Surname = (strip_tags($Surname));
$EmailAddress = (strip_tags($EmailAddress));
$Username = (strip_tags($Username));
$Password = (strip_tags($Password));
$ConfirmPassword = (strip_tags($ConfirmPassword));

//ensure form has been completed

if ($Firstname&&$Surname&&$EmailAddress&&$Username&&$Password&&$ConfirmPassword) {

	// ensure both passwords match.

	if($Password==$ConfirmPassword) {


		echo $Firstname;
		echo "<br />";
		echo $Surname;
		echo "<br />";
		echo $EmailAddress;
		echo "<br />";
		echo $Username;
		echo "<br />";
		echo $Password;
		echo "<br />";
		echo $ConfirmPassword;
		echo "<br />";


		//check to see if username entered already exists.

		$sql = "SELECT username FROM users WHERE username = '$Username'";
		$check = mysql_query($sql);

		//count rows to ensure that username entered returns 0 rows.

		$rows = mysql_num_rows($check);
		$rowscheck = mysql_query($rows);

		if($rowscheck==0) {

			//check the email address is not already in use

			$sql2 = "SELECT Email_Address FROM users WHERE Email_Address = '$EmailAddress'";
			$check2 = mysql_query($sql2);

			//count rows to ensure that the email address entered does not already exist, rows should equal 0.

			$rows2 = mysql_num_rows($check2);
			$rowscheck2 = mysql_query($rows2);


			if($rowscheck2==0) {


				//register the user and insert details into database

				$register_sql = "INSERT INTO `billyboy_users`.`users` (`ID`,`First_Name`,`Surname`,`Email_Address`,`Username`,`Password`)
				VALUES ('$FirstName','$Surname','$Email_Address','$Username','$Password')";

				// display successful registration message.

				echo "You have successfully registered, please login";




			} else {

				echo "That Email Address has already been Registered, please wait while you are Redirected to the login page";



			}


		} else {


			echo "Sorry, that username is already in use, please try again";






		}




	}

	echo "The two passwords you entered did not match";

} else {

	echo "You did not complete all fields, please try again";


}

?>