Page 1 of 1

Subscribing to multiple event by many users - how to

Posted: Tue May 25, 2010 9:53 am
by gripper
Using php only.
Suppose I have a web site that has thousands of registered users and every users has the ability to advertise, let's say, a camping event, or several events. Without using cookies, what is the best way to log the interest (subscribing) of maybe hundreds of interested users in a particular event so that every registered user can see how many people are interested in that particular event and some very limited information on those who has subscribed to that event?

Re: Subscribing to multiple event by many users - how to

Posted: Tue May 25, 2010 10:58 am
by Eran
You should be using a many-to-many table to describe the relationship between users and events. Check out this guide on the MySQL site - http://dev.mysql.com/tech-resources/art ... ation.html