i want to show the notification of my posting.
but my script cann't working
i have 4 table - user, group, article, comment
user :
id_user username
1 | user1
2 | user2
3 | user3
group :
id_group name content
1 | Script
2 | Math
article :
id_news |id_group | title content
1 | 1 | PHP | how we can learn PHP?
2 | 2 | HTML | how we can learn html?
3 | 1 | PHPagain | how we can learn PHP again?
Comment
id_comment id_news comment
1 | 1 | in school we can learn PHP
2 | 1 | in my web we can learn PHP
3 | 2 | HTML is easy in w3schools
4 | 3 | in my web we can learn PHP again
Result :
Notification (3 comment)
1 Script - 2 comment (user1, user2)
2 Math - 1 comment (user3)
Sould i create new table? -table notification?
or only use query of my table?