Ok - I kind of have this working - I’m using a global variable (Value = [glo_notes]) and a php method to get the ‘notes’. I would like to have an icon on top of the bell - or change the bell color - when there are unread messages. Here’s my php code (so far) … stuck …
{today} =date(“Y-m-d”); //current date
//Get notice from table
$check_sql = “SELECT note”
. " FROM sec_notice"
. " WHERE publish_date = ‘" . {today} . "’";
sc_lookup(rs, $check_sql);
if (isset({rs[0][0]})) // Row found
{
[glo_note] = {rs[0][0]};
}
else // No row found
{
[glo_note] = ‘’;
}
//If there are notes, show an icon or color the thing or display alert or something
sc_lookup(ds, “SELECT COUNT(note) FROM sec_notice”) ;
if({ds} >= 1) {
}