How to solve this? Commentary subscription
Posted: Wed Jan 27, 2010 1:47 pm
Hi there,
I'm having a small page with ~30 users, and I'm using the same MySQL-table for a comment system I made. The field 'type' indicates if it's a picture, movie or what, and the field 'parents' indicates the picture/movie id. But I want some a subscription feature (notification on new comments). It should send an email to the users that's checked the 'subscribe' checkbox. So I'm thinking about making another table for subscription list, but I'm not sure how I should do it. Any ideas?
I'm having a small page with ~30 users, and I'm using the same MySQL-table for a comment system I made. The field 'type' indicates if it's a picture, movie or what, and the field 'parents' indicates the picture/movie id. But I want some a subscription feature (notification on new comments). It should send an email to the users that's checked the 'subscribe' checkbox. So I'm thinking about making another table for subscription list, but I'm not sure how I should do it. Any ideas?