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 Received on Fri Aug 31 06:48:43 2007