</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 -->
Example #2
0
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>';
    }
}