next.php

<?php

	$capt = $_POST["captain"];
	$team = $_POST["teamno"];

	//echo $capt.$team;
$servername = "localhost";
$username = "root";
$password = "tubul8794";
$dbname = "SAS";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
     die("Connection failed: " . $conn->connect_error);
}

$sql1 = "SELECT * FROM list WHERE id = '$team' ";
$result1 = $conn->query($sql1);
$row1=$result1->fetch_assoc();
$sql2= "SELECT * FROM players WHERE Name = '$capt' ";
$result2 = $conn->query($sql2);
$row2=$result2->fetch_assoc();
//$capt1= $row1["captain"];
{
//echo $row1["points"];
//echo $row2["points"];

$sql= "UPDATE list SET captain = '$capt' WHERE id = '$team'";
if($conn->query($sql)===TRUE)
	echo "New captain name: ".$capt." for team ".$team."<br>";

$count=$row1["points"]+$row2["points"];
$sql = "UPDATE list SET points = '$count' WHERE id = '$team'";
if($conn->query($sql)===TRUE)
	echo "New Points:".$count;
}

	
echo "</br>"."<a href=drop.html>Click Here to return to bidding!</a>";
echo "</br>"."<a href=fourth.html>Click Here to Display team !</a>";
$conn->close();
 ?>