where_not_in (Solved)

[eluser]jedd[/eluser]
Agreed about the benefits of consistency.

Looks like you've got two approaches then - either modify your selection criteria, removing the items already subscribed to - and you can do that either by running a select query first, and massaging the output into something you can plug into the query, or do an encapsulated (SELECT...) within the one query, and put the resultant data in a 'NOT IN (...)' construct.

Second option is to try to process your array of objects into an array of serialise()'d objects, and then do the array_diff(), and see what happens. CI objects contain lots of surprises (try doing a var_dump of one from each of your arrays you're playing with now, say, and seeing if there's something obvious and fixable).