hi guys
i want to make an message system. in the system there are advisors, a coordinator and students. Coordinator can send message both to advisors and to students, also advisor can send both to students and to the coordinator, and also students.
i want to use sql server while doing this. i created a message table in the db, and there are message id,sender,receiver,is open,opened and context fields.
when somebody wants to send a message firstly it must be saved on the db. For example coordinator send a message to one advisor John. When John opens it message system and clicks unopened messages it must be seen here. Go to the complete details ...