action on view for pending leaves (admin) not showing the leave form.

below is my code <?php error_reporting(0); include('includes/start.php'); include('includes/header.html'); require_once('../dbcon.php'); $query = "SELECT leaves.leaveid, employee.eid, leaves.fdate, leaves.eid, fname, lname, leavetype, DATE_FORMAT(edate, '%M %d, %Y') AS dts, DATE_FORMAT(endate, '%M %d, %Y') AS dte, DATEDIFF(endate, edate) AS dtot, reason, recommending FROM leaves, employee WHERE leaves.eid = employee.eid and leaves.deanstatus= 'pending' and employee.eid='$_GET[id]'"; $result = mysqli_query($con, $query); if($result){ while($row = mysqli_fetch_array($result)){ $d = $row['fdate']; list($yr, $mon, $day) = explode("-",$d); require_once('month.php'); $fdate = $mon." ".$day.", ".$yr ; echo "<br>"; echo "<center><b>NZOIA SUGAR COMPANY LIMITED<br>"; echo "LEAVE FORM</b></center>"; echo '<table align="center" height="248"> <br> <center>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp <b>Date:</b>&nbsp;&nbsp;'.$fdate.'</center> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <b>To the College Director<br> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I have the honor to request for:</b></center> <tr> <td><b>Employee ID:</b></td><td>'.$row['eid'].'</td></tr> <tr> <td><b>Employee Name:</b></td> <td>'.$row['fname'].' '.$row['lname'].'</td></tr> <tr> <td><b>Leave Type:</b></td> <td>'.$row['leavetype'].'</td></tr> <tr> <td><b>Effective:</b></td> <td>'.$row['dts'].' &nbsp;<b>TO</b> &nbsp;'.$row['dte'].'</td></tr> <tr> <td><b>Total Days:</b></td> <td>'.$row['dtot'].'</td></tr> <tr> <td><b>Reason:</b></td> <td>'.$row['reason'].'</td></tr> <tr> <td>&nbsp;</td> <td align="left"><br><a href="approve.php?id='.$row['leaveid'].'"><img src="../images/approval.jpg" width="95" height="20"/></a> &nbsp; <a href="deny.php?id='.$row['leaveid'].'"><img src="../images/disapproval.jpg" width="95" height="20"/></a></td></tr> </tr>'; } echo '</table>'; mysqli_free_result($result); } mysqli_close($con); include('../includes/footer.html'); ?>

Answers