php html submit,html - PHP form submiting - Stack Overflow

I have a form with four values, player1, player2, awayTeam, and homeTeam.

After checking if values are not empty it does not want to send results to database. I am not sure why it does not want to submit.

There are as well two random numbers which will be compared and based on if num1 > num2 record should be submitted.

$link = mysqli_connect("localhost","test", "passowrd", "test" );

if (mysqli_connect_error()) {

die ("DB has not been connected");

}

// create two random numbers

$Num1 = rand();

$Num2 = rand();

if (isset($_POST['submit'])) {

$playerOne = mysqli_real_escape_string ($link, $_POST['playerOne']);

$playerTwo = mysqli_real_escape_string ($link, $_POST['playerTwo']);

$awayTeam = mysqli_real_escape_string ($link, $_POST['awayTeam']);

$homeTeam = mysqli_real_escape_string ($link, $_POST['homeTeam']);

//check if player one is empty

if (empty($playerOne)) {

echo "Game Creator PSN required!" . "
";

}

//check if player two is empty

if (empty($playerTwo)) {

echo "Second Player PSN required!";

}

} else {

//compare two numbers

if ($Num1 > $Num2) {

$sql = "INSERT INTO randomizer (playerOne, playerTwo, awayteam, homeTeam) VALUES (' $playerOne', '$playerTwo', '$awayTeam', '$homeTeam')";

if ($link->query($sql) === true) {

echo "Record Added Sucessfully";

} else {

echo "There was a problem";

}

} else {

$sql = "INSERT INTO randomizer (playerOne, playerTwo, awayteam, homeTeam) VALUES (' $playerTwo', '$playerOne', '$awayTeam', '$homeTeam')";

if ($link->query($sql) === true) {

echo "Record Added Sucessfully";

} else {

echo "There was a problem";

}

}

}

?>