prepare("SELECT COUNT(message) FROM messenger where toid = ? AND readit != ?"); $uid = $db->intcast($_SESSION['uid']); $readit = 1; $stmt->bind_param("ii", $uid, $readit); $stmt->execute(); $query = $stmt->get_result(); while($row = $query->fetch_array(MYSQLI_ASSOC)) { $messages[] = $row; } if($messages[0]["COUNT(message)"] >=1) { $newmessenger = $messages["COUNT(message)"]; $showbubblewarning = true; } } if(isset($_REQUEST['mobile']) == true || $mobile == true) { } else { ?>
'.$newmessenger.''; } echo "
"; } ?>