calendar: every date with id

[eluser]Unknown[/eluser]
hello guys,

i just need a helping hand.

I coded an event calendar from a tutorial on this site:"http://net.tutsplus.com/tutorials/php/codeigniter-from-scratch-the-calendar-library/"

and now ive got a problem...

i cant post any code here...

so i hope u can help me without it.

i want to give any day an spezific id like:

date .... ... date_id
2010/01/01 = id 1
2010/01/02 = id 2

so i can have more events on 1 day.(ma_id is just like it is in my work.its staff_id) like:

date_id event_id ...... ma_id
1 .... .... 3 .... 2
1 .... .... 3 .... 2
4 .... .... 2 .... 4

(.... dots are just for better formatting.sry for this.)
on this date its christmas(event) and worker "smith" has holiday(also in my work)


hope u can help me out. how i can give every date an id...and maybe how i can write my tables in the database.

(sorry for bad english, im german)



greets

jeno

[eluser]tonanbarbarian[/eluser]
why not just make the date field the primiary key, or part of the primary key of the table

[eluser]Unknown[/eluser]
so now i just need and date_id when there is an event...


he only generates and date/id when there is an event....




this thread is just freezed and im going to ask again when im done....