+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: calendar: every date with id (/showthread.php?tid=35555)
calendar: every date with id - El Forum - 11-03-2010
[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
calendar: every date with id - El Forum - 11-03-2010
[eluser]tonanbarbarian[/eluser]
why not just make the date field the primiary key, or part of the primary key of the table
calendar: every date with id - El Forum - 11-03-2010
[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....