newest 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) {


		//check to see if username entered already exists.

		$sql = "SELECT username FROM `billyboy_users`.`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 `billyboy_users`.`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` (`First_Name`,`Surname`,`Email_Address`,`Username`,`Password`,`Confirm_Password`)
VALUES ('".$FirstName."','".$Surname."','".$Email_Address."','".$Username."','".$Password."', '".$ConfirmPassword."')";

				// 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";


}

?>