Commit | Line | Data |
---|---|---|
e3599ddc PM |
1 | <?PHP |
2 | include_once('security.php'); | |
3 | include_once('header.php'); | |
9970efb3 | 4 | slack_general('ADMIN: Reports Loaded ('.$_COOKIE['name'].') ('.$_COOKIE['level'].')','md-petition'); |
f1f9b284 | 5 | $group_id = $_COOKIE['group_id']; |
66c9275f | 6 | $q="SELECT * FROM petitions where group_id = '$group_id' and admin_status = 'approved'"; |
f1f9b284 | 7 | $r = $petition->query($q); |
d156fc32 | 8 | $hide = array(); |
f1f9b284 PM |
9 | while($d = mysqli_fetch_array($r)){ |
10 | echo "<h1>$d[petition_name]</h1>"; | |
66c9275f | 11 | $pID = $d['petition_id']; |
d156fc32 | 12 | $q2="SELECT * FROM signatures where petition_id = '$pID' order by id desc"; |
f1f9b284 PM |
13 | $r2 = $petition->query($q2); |
14 | while($d2 = mysqli_fetch_array($r2)){ | |
d156fc32 PM |
15 | if (!in_array($d2['VTRID'], $hide)) { |
16 | $hide[] = $d2['VTRID']; | |
17 | echo "<li>$d2[date_time_signed] $d2[signed_name_as] $d2[signed_name_as_circulator] $d2[contact_phone]</li>"; | |
18 | } | |
f1f9b284 PM |
19 | } |
20 | } | |
e3599ddc | 21 | |
e3599ddc PM |
22 | include_once('footer.php'); |
23 | ?> |