I'm trying to create a message system and i would like to show a badge that show the number of "unread messages". What i've done until now is:
- Create a message table with: ID, Title, Date, Message text and 15 field (that are the number of users) that hold "read" or "unread" values.
How can I count the number of "unread" messages from message table (and this for all users)?
How can I hold different values for different users?