Update report.php

diff --git a/admin/report.php b/admin/report.php
index 576d2d5..feb95c0 100644 (file)
--- a/admin/report.php
+++ b/admin/report.php
@@ -55,7 +55,7 @@ while($d = mysqli_fetch_array($r)){
        $r3 = $core->query($q3);
        $total=0;
        while ($d3 = mysqli_fetch_array($r3)){
-         $q2 = "SELECT * FROM signatures where petition_id = '$pID' and just_date = '$d3[just_date]' ";
+         $q2 = "SELECT * FROM signatures where petition_id = '$pID' and just_date = '$d3[just_date]' and signature_status = 'verified'  ";
          $r2 = $core->query($q2);
          $count  = mysqli_num_rows($r2);
          $chart .=  '{ label: "'.$d['just_date'].'", y: '.intval($count).' }, ';