<?php
                       $hostname="localhost";
                       $username="root";
                       $password="";
                       $db = "usman";

                       $dbh = new PDO("mysql:host=$hostname;dbname=$db", $username, $password);

                     foreach($dbh->query("SELECT COUNT(*) as cnt
                   FROM ams
                   where empid= {$_SESSION['sess_user_id']}
                  GROUP BY leavetype
                  HAVING leavetype = 'HalfDay'") as $HalfDay)
                   {
                         echo "<table ><tr ><td style='border: 0px; '>" . $HalfDay['cnt'] . "</td></tr></table>";
                    echo "<br>";
                        }
                        ?>