Untitled

<!DOCTYPE html>
<html>
<body>

<?php
$servername = "localhost";
$username = "cocohead781";
$password = "Webkins!";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";

$db_selected = mysql_select_db('vote', $link);
if (!$db_selected) {
    die ('Can\'t use foo : ' . mysql_error());
}

$add = mysql_query("SELECT SUM(yes) FROM vote WHERE yes >= 1;")or die(mysql_error());
list ( $rsvp_total ) = mysql_fetch_array($add);

echo $rsvp_total;

$add = mysql_query("SELECT SUM(no) FROM vote WHERE no >= 1;")or die(mysql_error());
list ( $rsvp_total ) = mysql_fetch_array($add);

echo $rsvp_total;
?>

</body>
</html>