Fwd: Calendar event query

2007-08-31 Thread abhishek jain 
On 8/30/07, C.R.Vegelin [EMAIL PROTECTED] 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 [EMAIL PROTECTED]
 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
  235 7
  237 8
  246 6
  254  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

Calendar event query

2007-08-30 Thread abhishek jain 
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
235 7
237 8
246 6
254  6
26   10 6
27   15
.

Pl. help me
Thanks,
Abhishek jain