";
$q="SELECT * FROM follow_up where status <> 'NEW'";
$r = $petition->query($q);
while($d = mysqli_fetch_array($r)){
$sig = '';
if ($d['name'] != ''){
$q3 = "SELECT date_time_signed FROM signatures where signed_name_as = '$d[name]'";
$r3 = $petition->query($q3);
$d3 = mysqli_fetch_array($r3);
if ($d3['date_time_signed'] != ''){
$sig = "SIGNATURE $d3[date_time_signed]";
}
}
$presig='';
$q4="SELECT * FROM presign where email_for_follow_up = '$d[email]' and php_page like '/sign.php%'";
$r4 = $petition->query($q4);
$d4 = mysqli_fetch_array($r4);
if ($d4['action_on']){
$presig = "PRESIG $d4[action_on]";
}
echo "$d[date_sent] $d[email] $presig $d[name] $sig";
}
echo "";
include_once('footer.php');