return is_object($properties) ? $properties->name : null;
}
if ($_COOKIE['level'] == 'admin'){
- $q = "SELECT date_time_signed, signed_name_as, printed_status FROM petitions where signature_status = 'verified' ORDER BY id";
+ $q = "SELECT date_time_signed, signed_name_as, VTRID, petition_id, VoterList_table FROM signatures where signature_status = 'verified' ORDER BY id";
}else{
- $q = "SELECT date_time_signed, signed_name_as, printed_status FROM petitions where petition_id = '$_COOKIE[petition_id]' and signature_status = 'verified' ORDER BY id";
+ $q = "SELECT date_time_signed, signed_name_as, VTRID, VoterList_table FROM signatures where petition_id = '$_COOKIE[petition_id]' and signature_status = 'verified' ORDER BY id";
}
$r = $petition->query($q);