[Solved] Codeigniter Query Misses First One Off List

I don't see exactly where the problem occurs, but you should consider using a join to retrieve the results in a single query, rather than making an additional query for each result of the first query. Regardless of whether it makes it easier to generate the output, it will speed things up, especially when you have more events in the database.

Bonfire

Practical CodeIgniter 3
CodeIgniter Testing Guide