events calendar

[Anon]

i want to build an event calendar database table.

i am thinking about two approaches

1) with one field called "eventdate" of DATE type, and all the future SQL deal with the even date will be dealing with the "eventdate" DATE field values, such as pick up certain month, or certain year events, check out events 30 days from now etc.

2) with this field "eventdate", plus with three other integer fields "eventmonth", "eventday", and "eventyear", so the future SQL may directly deal with these three fields directly, such as pick up events of March.

I don't have to manipulate "eventdate" DATE field.

I can simply call

select * from eventcalendar where eventmonth=3

which way is better?

hui

[bastien]

use #1, and realize that you can call other dates by manipulating the SQL to get you number two....

but store the date as one full item...

hth

bastien

[Anon]

I have a calendar already made if you want it. you may have to manipulate some of the code but it works.

[Anon]

thanks, i just finish my codes seconds ago. i should ask early to save me time by not reinventing the wheels.

hui