SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 07:00 AM
| ||||
| ||||
 Calendar event query Hi friends, I need to make a calendar with some events. I have created an events table with the parameters like: eventid event_from event_till recurring recurring_after_day event_type userid and so on. My problem is to prepare a query which can give me events on a particular day or rather all days(in case of calendar view is daily) ,months(if view is monthly) and so on for year week including for events which are repeated also, so that i can show that on my calendar.The query will run on a fairly large no of users also so it should be efficient. I think the catch is about the recurring events. As for them the entry will be in one row and they will have virtually many rows one for each recurring event. So i want somthing like this for a particular userid : event_on count(*) event_type 23 5 7 23 7 8 24 6 6 25 4 6 26 10 6 27 15 ...... Pl. help me Thanks, Abhishek jain      |
|
02-28-2008, 07:00 AM
| ||||
| ||||
| Fwd: Calendar event query On 8/30/07, C.R.Vegelin <cr.vegelin@hetnet.nl> wrote: > > Hi Abhishek, > > Maybe it's off topic, but do you know: > http://dev.mysql.com/downloads/other/eventum/ > a ready-to-use issue tracking system ... > maybe also suitable for your purposes. > > Regards, Cor > > ----- Original Message ----- > From: "abhishek jain" <mail@ejain.com> > Subject: Calendar event query > > > > Hi friends, > > I need to make a calendar with some events. > > I have created an events table with the parameters like: > > eventid > > event_from > > event_till > > recurring > > recurring_after_day > > event_type > > userid > > > > and so on. > > My problem is to prepare a query which can give me events on a > particular > > day or rather all days(in case of calendar view is daily) ,months(if > view > > is > > monthly) and so on for year week including for events which are repeated > > > also, so that i can show that on my calendar.The query will run on a > > fairly > > large no of users also so it should be efficient. > > > > I think the catch is about the recurring events. As for them the entry > > will > > be in one row and they will have virtually many rows one for each > > recurring > > event. > > > > So i want somthing like this for a particular userid : > > event_on count(*) event_type > > 23 5 7 > > 23 7 8 > > 24 6 6 > > 25 4 6 > > 26 10 6 > > 27 15 > > ..... > > > > Pl. help me > > Thanks, > > Abhishek jain > > > > > Hi , eventum will not solve my purpose. Pl. reply the calendar script is urgent and i need a query to actually give me all events within a time period including the recurring events, Thanks, Abhishek jain |
Linear Mode
