i need to print the sum of counters of unread note for more than one if i have 2 or more person


kranky
26/4/2016 6:52 am
HOME ยป Web Development

this code shows to me every student that do not read the notes so I need the counter of these unread to print it how can get the sum of all unread notes ?

 $query=mysql_query("SELECT * FROM students WHERE
parents_id='".$pid."'");
while($r=mysql_fetch_assoc($query)){
echo'<tr>';
echo'<td><b>'.$r['first_name'].'  '.
$r['last_name'].'</b></td>';
echo'<td>'.$r['class_name'].'</td>';
$quer=mysql_query("SELECT count(id) FROM notes  WHERE
student_id='".$r['id']."' AND isread='0' ");
$count=mysql_fetch_array($quer);
$c=$count[0];
echo'<td><b><span
style="color:red;text-align:center;">('.$c.')
'.'UnRread</b></td>';
echo'<td><b>'."<a
href=viewnote.php?viewnote&sid=".$r['id']."&name=".$r['first_name']."&last=".$r['last_name']."'
>View</a>".'</b></td>';
echo'</tr>';

Related to : i need to print the sum of counters of unread note for more than one if i have 2 or more person
i need to print the sum of counters of unread note for more than one if i have 2 or more person
26/4/2016 6:52 am Web Development

this code shows to me every student that do not read the notes so I need the counter of these unread to print it how can get the sum of all unread notes ?

 $query=mysql_query("SELECT * FROM students WHERE
parents_id='".$pid."'");
while($r=mysql_fetch_assoc($query)){
echo'<tr>';
echo'<td><b>'.$r['first_name'].'  '.
$r['last_name'].'</b></td>';
echo'<td>'.$r['class_name'].'</td>';
$quer=mysql_query("SELECT count(id) FROM notes  WHERE
student_id='".$r['id']."' AND isread='0' ");
$count=mysql_fetch_array($quer);
$c=$count[0];
echo'<td><b><span
style="color:red;text-align:center;">('.$c.')
'.'UnRread</b></td>';
echo'<td><b>'."<a
href=viewnote.php?viewnote&sid=".$r['id']."&name=".$r['first_name']."&last=".$r['last_name']."'
>View</a>".'</b></td>';
echo'</tr>';

Exchange Account Unread counters (not inbox)
Web Development

Hi guys,
Has anyone else experienced this? The unread counter on my "Sent" folder seems to show a lot of messages as unread, but there's really none (all are marked read, in any case...and why would I have unread messages on my Sent folder?...I sent them!). The unread counter in my Inbox works fine, it's just the Sent one that's not working properly.
Also, if anyone knows how to get the app to properly sync up that'd be great hehe (the e-mails I read on my computer or phone, show up as new e-mails in my Tablet... sure, when I open the Inbox they sync and show as read, but still, annoying to have those notifications 'waiting' when I've already read them
unread count stopped working on stock note 3
Web Development

I can swear until today I had the unread badge working on my stock 4.3 galaxy note 3. It was working on facebook, email, gmail, and whatsapp (not sure about this last one though). Suddenly they are gone! Can someone help??
Linux RSS reader to print all unread articles
Web Development

I am looking for a linux based RSS reader that I can script to refresh and automatically print all new unread articles (images in this case)


Thanks!




HD Wallpapers
3D
3D Abstract
City
Celebrities
Indian Celebrities
Cars
Travel
Girls
Animals Birds
Movies
Sports
Black White
Nature
Planes
Anime
Food Drink
Dreamy Fantasy
Architecture
Games
Space
Holidays
Flowers
Love
Artistic
Baby
Beach
Bikes Motorcycles
Macro
Computers
Vector
Funny
Army
Textures
Brands
Misc
Music
Other
Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .