</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);