<?php
$host = "********" ;
$db = "*******" ;
$dbuser = "***********" ;
$dbpass = "*********" ;
$con = mysql_connect($host, $dbuser, $dbpass);
if(!$con){
die(mysql_error());
}

$select = mysql_select_db($db, $con);
if(!$select){
die(mysql_error());
}

$item = $_REQUEST['find'];

$data = mysql_query("SELECT * FROM requests WHERE status = 'OPEN'");

while($row = mysql_fetch_array($data)){

        $date_filled = $row['requested_time'];
        $date_filled = gmdate('d/m/Y', $date_filled);
        $time_filled = $row['requested_time'];
        $time_filled = gmdate('h:m:s', $time_filled);

        echo "<tr>";
        echo "<td align=center>",$row['reqid']," ","</td>";
        echo "<td align=center>",$row['section']," ","</td>";
        echo "<td>",$row['type']," - " ,$row['rlsname']," ","</td>";
        echo "<td align=center>",$row['requester']," ","</td>";
        echo "<td align=center>",$row['status']," ","</td>";
        echo "<td align=center><font size=2>",$date_filled,"<br>",$time_filled,"</font></td>";
        echo "</tr>";
        echo "</table>";
        echo "<br>";
        echo "<br>";
}
?>