title: How do I get a the pending status to automatically show up?
body: <p>I have this leave form where employees can apply for a leave. Everything works fine, the only problem is I can't get the pending status to show up. I've already defined the default value of <code>status</code> on my table. </p>
  
  <p>Here's what it looks like when I view the leaves:</p>
  
  <p><a href="https://i.stack.imgur.com/XuINJ.png" rel="nofollow noreferrer">view-leave</a></p>
  
  <p>and here's my table structure:</p>
  
  <p><a href="https://i.stack.imgur.com/4kpqG.png" rel="nofollow noreferrer">Table Structure</a></p>
  
  <p>I'm not sure if you guys need my view-leave code but here it is:</p>
  
  <p><div class="snippet" data-lang="js" data-hide="false" data-console="true" data-babel="false">
  <div class="snippet-code">
  <pre class="snippet-code-js lang-js prettyprint-override"><code>&lt;div class="table-responsive"&gt;
  &lt;table class="table"&gt;
   &lt;tr&gt;
    &lt;th&gt;Employee Name&lt;/th&gt;
    &lt;th&gt;Phone&lt;/th&gt;
    &lt;th&gt;Email&lt;/th&gt;
    &lt;th&gt;From&lt;/th&gt;
    &lt;th&gt;To&lt;/th&gt;
    &lt;th&gt;Reason&lt;/th&gt;
    &lt;th&gt;Status&lt;/th&gt;
   &lt;/tr&gt;
  &lt;?php
   include ('database.php');
   $result = $database-&gt;prepare ("SELECT * FROM leaves order by id DESC");
   $result -&gt;execute();
   for ($count=0; $row_message = $result -&gt;fetch(); $count++){
  ?&gt;
   &lt;tr&gt;
    &lt;td&gt;&lt;?php echo $row_message['full_name']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $row_message['phone']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $row_message['email']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $row_message['fromdate']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $row_message['todate']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $row_message['reason']; ?&gt;&lt;/td&gt;
    &lt;td&gt;&lt;?php echo $row_message['status']; ?&gt;&lt;/td&gt;
   &lt;/tr&gt;
   &lt;?php } ?&gt;
  &lt;/table&gt;
  
  &lt;a href="home"&gt;&lt;button type="button" class="btn btn-primary"&gt;&lt;i class="glyphicon glyphicon-arrow-left"&gt;&lt;/i&gt; Back&lt;/button&gt;&lt;/a&gt;
  
  &lt;/div&gt;
  &lt;/div&gt;</code></pre>
  </div>
  </div>
  </p>