My CI Hacks Pt 1

[eluser]xwero[/eluser]
b : i don't think your query works with all databases. mysql versions lower than 5 don't have the ability to process subqueries.

d a : i love the idea of simplifying the output but why d0 you use !empty($indexfield) and not !is_null($indexfield) (or the optimized $indexfield !== null).
I'm also wondering if you use the indexfield as the key will you not overwrite your values?

f : great find with the media group is_video, is_image lays just around the corner

Overall a nice contribution i will be waiting for the second part