0) { echo "

"; } $nquery = mysqli_query($conx, "SELECT id,app_uqid,message,view_link,tstamp,rstring,snoozeable FROM notifs WHERE uid='$u_uid' ORDER BY id DESC"); while ($nrow = mysqli_fetch_assoc($nquery)) { $notifid = $nrow['id']; $app_uqid = $nrow['app_uqid']; $app_msg = $nrow['message']; $app_link = $nrow['view_link']; $app_tst = $nrow['tstamp']; $nrstr = $nrow['rstring']; $nsnoozb = $nrow['snoozeable']; $apdq = mysqli_query($conx, "SELECT uqid,title,app_color,link FROM apps WHERE uqid='$app_uqid'"); while($ap = mysqli_fetch_assoc($apdq)) { $app_color = $ap['app_color']; $app_name = $ap['title']; } $asno = mysqli_query($conx, "SELECT snooze FROM user_apps WHERE app_uqid='$app_uqid' && uid='$u_uid'"); while($nz = mysqli_fetch_assoc($asno)) { $app_snooze = $nz['snooze']; } echo "

$app_name • "; echo timeago($app_tst); echo " ago
$app_msg

"; //only echo a view link if one is there if($app_link) { echo "view "; } // snooze if($nsnoozb == 'yes') { if($app_snooze == 'yes') { echo "wake "; } else { echo "snooze "; } } echo "dismiss

"; } $extra = mysqli_query($conx, "SELECT uid FROM notifs WHERE uid='$u_uid'"); $ncount = mysqli_num_rows($extra); if($ncount == '0') { echo "

Alerts
You don't have any alerts.

"; } else { mysqli_query($conx, "UPDATE notifs SET viewed='yes' WHERE uid='$u_uid'"); } ?>