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 Received on Thu Aug 30 10:46:36 2007