query($q); $d = mysqli_fetch_array($r); if ($d['VTRID'] != ''){ $VTRID = $d['VTRID']; $FIRSTNAME = $d['FIRSTNAME']; $MIDDLENAME = $d['MIDDLENAME']; $LASTNAME = $d['LASTNAME']; $ADDRESS = $d['ADDRESS']; $RESIDENTIALCITY = $d['RESIDENTIALCITY']; $COUNTY = $d['COUNTY']; $RESIDENTIALZIP5 = $d['RESIDENTIALZIP5']; }else{ header('Location: warning_not_found.php'); } if (isset($_GET['remove'])){ $id = $_GET['remove']; $q = "update signatures set signature_status = 'removed' where id = '$id'"; $petition->query($q); header('Location: eligible.php'); } echo $head; $available=''; $q2 = "SELECT * FROM petitions"; $r2 = $petition->query($q2); while($d2 = mysqli_fetch_array($r2)){ $checked = ''; $field = $d2['eligibleVoterListField']; $pass = $d2['eligibleVoterListEquals']; $q4 = "select * from signatures where VTRID = '$VTRID' and petition_id = '$d2[petition_id]' and signature_status <> 'removed' "; $r4 = $petition->query($q4); $d4 = mysqli_fetch_array($r4); if ($d4['id'] > 0){ $available .= "
Already Signed, View or Remove
$d2[petition_name]
$field == $pass
"; }elseif($d[$field] == $pass){ $checked = ''; if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){ $checked = 'checked'; }else{ $checked = ''; } $available .= "
$d2[petition_name]
$field == $pass
"; if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){ $available .= ''; } }else{ $checked = ''; if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){ $checked = 'checked'; }else{ $checked = ''; } $available .= "
$d2[petition_name]
$field != $pass
"; if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){ $available .= ''; } } } ?>

Active Petitions and Eligiblity Requirements to Sign.

Pick One

Petition Name

Requirements

Petition History

Date

Petition Name

Status

'removed'"; $r4 = $petition->query($q4); while($d4 = mysqli_fetch_array($r4)){ ?>
'>Signed - View or '>Remove