• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
calendar: every date with id

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)



why not just make the date field the primiary key, or part of the primary key of the table

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....

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.