Recurring Events

[Glyde]

I'm currently working on a calendar which can be found here: http://24.2.61.27/projects/calendar/

In essence, I'm aiming to make a web-based Outlook 2007 calendar.  Seeing as I have just finished getting the months to display correctly, I'm off to my next task which would be the ability to create events.  I find it quite easy to make ranged and standard events, but trying to create recurring events has proven to be a little more tedious.  I was wondering what your thoughts were about how I could make this work.  Should I use UNIX timestamps or a DATETIME field.  I figured DATETIME would be advantageous since MySQL has great date and time management functions, but it has poor built-in support for timezones.  But even beyond that, what would be the best way to go about recurring events.  I have been sitting here trying to think about the best way to go about it, but nothing really comes to mind.

[Glyde]

Just as a note, I have tried using both UNIX timestamps and a DATETIME field, each with it's own issue.  UNIX timestamps proved a lack of support within MySQL, and DATETIME provides a lack in PHP.  I had a recurring event that recurred every week and started a month ago, but the problem was that I had to waste tons of while loops of virtually no code until I got to the start of the current month.  It was like a waste of resources.  Anyways, I'm just trying to discover the best way of doing this without killing resources.