</ul> <!-- /.dropdown-tasks --> </li> <!-- /.dropdown --> <li class="dropdown"> <a class="dropdown-toggle" data-toggle="dropdown" href="#"> <i class="fa fa-bell fa-fw"></i> <i class="fa fa-caret-down"></i> </a> <ul class="dropdown-menu dropdown-alerts">'; $getSQLdata = mysql_query("SELECT * FROM `red_alert` where CURRENT_STATUS ='new' OR CURRENT_STATUS='resolving' order by DATE_OF_ALERT") or die(mysql_error()); while($rowData = mysql_fetch_array($getSQLdata)){ echo '<li> <a href="#"> <div> <i class="fa '.red_alert_types($rowData['ALERT_TYPE']).' fa-fw"></i> '.$rowData['COMMENT'].' <span class="pull-right text-muted small">'.getDateFromNow($rowData['DATE_OF_ALERT']).'</span> </div> </a> </li> </li> <li class="divider"></li>'; } echo '<li class="divider"></li> <li> <a class="text-center" href="#"> <strong>See All Alerts</strong> <i class="fa fa-angle-right"></i> </a> </li> </ul> <!-- /.dropdown-alerts -->
function getRedAlerts() { $getSQLdata = mysql_query("SELECT * FROM `red_alert` where CURRENT_STATUS ='new' OR CURRENT_STATUS='resolving' order by DATE_OF_ALERT") or die(mysql_error()); while ($rowData = mysql_fetch_array($getSQLdata)) { echo '<li> <a href="#"> <div> <i class="fa ' . red_alert_types($rowData['ALERT_TYPE']) . ' fa-fw"></i> ' . $rowData['COMMENT'] . ' <span class="pull-right text-muted small">' . getDateFromNow($rowData['DATE_OF_ALERT']) . '</span> </div> </a> </li> </li> <li class="divider"></li>'; } }