Alternate Lookup;







‘.’
‘;
if ($_SERVER[“REQUEST_METHOD”]==”POST”) {
$precinct = $_POST[‘precinct’];
$candidate = $_POST[‘candidate’];
$delegatetype = “Alternate”;
} else {
echo “No data posted”.”
“;
?>
Click Here To Try Again!

“;
}

//Find Alternate Delegates
$sql=”select delegateinfo_tbl.firstname, delegateinfo_tbl.lastname, delegateinfo_tbl.email, delegateinfo_tbl.phone, conventioninfo_tbl.candidate from delegateinfo_tbl inner join conventioninfo_tbl on delegateinfo_tbl.delegateid = conventioninfo_tbl.delegateid where delegateinfo_tbl.precinct = ‘$precinct’ and delegateinfo_tbl.delegatetype = ‘$delegatetype’ and conventioninfo_tbl.candidate =’$candidate'”;
$results = mysqli_query($connection, $sql);
If (mysqli_num_rows($results)==0) {
mysqli_close($connection);
echo “
No Alternates Found
“;
?>
Click Here To Try Again!

“;

while ($row = $results-> fetch_assoc()) {
echo “

“;
}
echo “

First Name Last Name Email Phone Candidate
” . $row[‘firstname’] . “ ” . $row[‘lastname’] . “ ” . $row[’email’] . “ ” . $row[‘phone’] . “ ” . $row[‘candidate’] . “

“;
?>


Click Here Continue