create table help plz

[IBazz]

Hi,

I am trying to create a table for listing events in a club. Some events are three day events and others are daily events. I am struglging to work out how to differentiate between the two types and ask for your help.

here is my table so far

create table if not exists events
( event_id int not null
, event_name varchar(32) not null
, description varchar (255) not null
, start_date date not null
, end_date date not null
, opening_time time not null
, closing_time time not null
, primary key (event_id)
key (start_date,end_date)
key (event_name)
) engine=innodb default chartset=latin1;

If I were to keep it like this, would adding a daily event which lasts for a week be quite tedious because each would have to be added as if separate events?

bazz

[r937]

you have 2 columns for start and end dates, and 2 columns for opening and closing times

so i assume that this is intended to allow things like "Todd's Fabulous Band", this week from Tuesday thru Saturday, each night from 5 p.m. until 1 a.m.

i would imagine you could differentiate a 3-day event from a 1-day event by checking to see if start_date was equal to end_date, but as you have anticipated, this means if you have 5 consecutive one-day events, you'd have 5 rows, but if you had a 5-day event, you'd have only one row

i'm not sure i understand your problem, because this seems fairly simple to me

[IBazz]

Thanks rudy I think you have cleared up my mind.

If adding an event which lasts for five days eg motor show, there would then be five rows and I (now), expect my processing script should be used to input five rows based on a form entry saving the admin from inputting 5 different entries.

bazz