</ul>
</nav>
</fieldset>
</form>
</header>
</div>
<!-- content -->
<div class="wrapper row2">
<div id="status">
<marquee behavior="scroll" direction="left" scrollamount="20"><?php
$db_handle = Connect_To_Server();
$db_found = Connect_To_DB();
view_dhobi();
echo " And ";
view_doctor();
Close_To_Server($db_handle);
function view_dhobi()
{
$SQL_Query = "select name from dhobi_status where present='i' limit 1";
$result = mysql_query($SQL_Query);
$out = mysql_fetch_assoc($result);
$name = $out['name'];
if ($name != "") {
echo "Dhobi {$name} Is Present";
} else {
echo "No Dhobi Is Present";
}
}
function view_doctor()
{
$SQL_Query = "select count(*) as counter from doctor where present='i' limit 1";
echo "<td>Serviced Date</td>";
echo "<td>Serviced Time</td>";
echo "<td>Descrption</td>";
echo "<td>Wing</td>";
//echo "<td>Floor</td>";
echo "<td>Room</td>";
while ($row = mysql_fetch_array($result)) {
$temp = $row["complaints_id"];
echo "<tr>";
echo "<td>" . $row["complaints_id"] . "</td>";
echo "<td>" . $row["id"] . "</td>";
//echo "<td>" . $row["Type"] . "</td>";
echo "<td>" . $row["posting_date"] . "</td>";
echo "<td>" . $row["posting_time"] . "</td>";
echo "<td>" . $row["serviced_date"] . "</td>";
echo "<td>" . $row["serviced_time"] . "</td>";
echo "<td>" . $row["description"] . "</td>";
echo "<td>" . $row["wing"] . "</td>";
//echo "<td>" . $row["floor"] . "</td>";
echo "<td>" . $row["room"] . "</td>";
}
?>
</body>
</html>
<?php
//5. close connection
Close_To_Server($db);
