How to Sort or Order By fields in Get_Event_List

Buff · Joined: 17 Feb 2007 Posts: 23

Anybody:

Now that I have get_event_list working, I have a need to sort the array on the cal_title field.

How can I do this?

Going a step further, can I do a primary sort on the cal_title field and a secondary sort on the event_title field or the event_location field using get_event?

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Hi Buff,

Is this a sort per day or an overall sort? E.g. would you no longer like to group the events by date?

Buff · Joined: 17 Feb 2007 Posts: 23

Hi Ian,

Since the calendar I'm using get_event_list for is a composite of nine calendars, representing nine districts across the US and Canada, I would like to sort the events by the individual calendars order first, and then by date within each calendar.

If you'll check my work at: http://nsrca.us/components/com_kcal/kcal.php?y=2008&m=5&d=8

I need to sort first by the District number, which is derived from the cal_title field, and then by the date.

I've tried using the PHP 'usort' in conjunction with my own compare function, but that seems to only sort on the date.

I could use get_event_list nine times for the individual calendars, but that doesn't seem to be very elegant programming to me.

esoft_ian · Joined: 12 Sep 2005 Posts: 5275

Long story short (let me know if you need more and I'll be happy to provide), use usort but do something like this in your custom sort function: