Hi,

I'd like to send global notifications to my users (1000+ users) and allow them to close the notification box once they have read the message.

Basically I may send one notification per week globally ie/ each user get the same message and they are not personal in nature.

What is the best way to achieve this?

Create 2 tables:

**tb_messages**
message_id
massage_title
message_content

**tb_read_messages**
user_id
message_id
is-read

That way i can just show each user the current notifications that are not read?

select * from tb_read_messages WHERE user_id = $user_id AND is-read = no

OR is there a more efficient way?

Thanks!!!