I have a site, which tracks user's wish lists (mainly for Christmas lists at this time). It keeps track of wish lists based on group, wish list items, and comments on those wish list items.
With my actively used group, we have 13 users with around 150 wish list items/comments. It quickly grew beyond the scope of checking every page. I need a way to list unread items. Specifically, I have three in mind: new members to the group (therefore, new wish lists), new wish list items, and new comments.
I was thinking of the best way to do this and it seems like the most accurate way is to create a new table that lists every item that was read. So, if the item is not found, it has not been read. The site is still very small but I'm not sure if this could quickly grow exponentially and be a bad choice.
Anyway, I need help getting the mysql code down. How can I compare two tables.... Tables "groups" and "pageViews" track this. I'm using an ID on pageViews to identify if the item is a groupmember, wishlist item, or comment. Then, the ID # refers to that type.
Group members are identification number 0. So I need all items from "groups" returned where an entry DOES NOT exist in "pageViews" ... this is a tricky one, I think!
With my actively used group, we have 13 users with around 150 wish list items/comments. It quickly grew beyond the scope of checking every page. I need a way to list unread items. Specifically, I have three in mind: new members to the group (therefore, new wish lists), new wish list items, and new comments.
I was thinking of the best way to do this and it seems like the most accurate way is to create a new table that lists every item that was read. So, if the item is not found, it has not been read. The site is still very small but I'm not sure if this could quickly grow exponentially and be a bad choice.
Anyway, I need help getting the mysql code down. How can I compare two tables.... Tables "groups" and "pageViews" track this. I'm using an ID on pageViews to identify if the item is a groupmember, wishlist item, or comment. Then, the ID # refers to that type.
Group members are identification number 0. So I need all items from "groups" returned where an entry DOES NOT exist in "pageViews" ... this is a tricky one, I think!
