Update A Database Help

[artisticre]

I am confused on how to setup a database. I have a database that is for events. The basic stuff..Event, Date, Time, Contact...Someone will go in and insert the event information. I want to be able to update the database to allow peopel from my church to sign up for a particular event. Basically, one event will have one to many people signing up. My confusion is the database. I am new at creating databases. Without creating a lot of redundancy, how do I create a database with one entry of an event to allow several users to sign up? Any examples would be helpful.

Thanks

[bastien]

three tables

events
event_id
event_name
event_date
etc

people
person_id
p_fname
p_lname
etc

people_events
id (autonumber)
event_id
person_id
etc

hth

[devinemke]

i agree with bastien and i'll add a bit more detail. table structure:

CREATE TABLE `users` (
  `user_id` smallint(4) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `email` varchar(50) default NULL,
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

CREATE TABLE `events` (
  `event_id` smallint(4) NOT NULL auto_increment,
  `name` varchar(50) default NULL,
  `date_time` datetime default NULL,
  `location` varchar(25) default NULL,
  PRIMARY KEY  (`event_id`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

CREATE TABLE `event_link` (
  `event_link_id` smallint(4) NOT NULL auto_increment,
  `user_id` smallint(4) default NULL,
  `event_id` smallint(4) default NULL,
  PRIMARY KEY  (`event_link_id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

then lets say you want to know all of the events that user number 7 is signed up for:

SELECT events.*, event_link.event_id FROM events, event_link WHERE events.event_id = event_link.event_id AND event_link.user_id = 7

or who's coming to event number 10:

SELECT users.*, event_link.user_id FROM users, event_link WHERE users.user_id = event_link.user_id AND event_link.event_id = 10