Subscribing to multiple event by many users - how to

Not for 'how-to' coding questions but PHP theory instead, this forum is here for those of us who wish to learn about design aspects of programming with PHP.

Moderator: General Moderators

Post Reply
gripper
Forum Newbie
Posts: 1
Joined: Tue May 25, 2010 9:28 am

Subscribing to multiple event by many users - how to

Post 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?
User avatar
Eran
DevNet Master
Posts: 3549
Joined: Fri Jan 18, 2008 12:36 am
Location: Israel, ME

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

Post 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
Post Reply