Check if a value exist i a query

[eluser]jedd[/eluser]
[quote author="fredrik.carlsen" date="1251052364"]I know how to use active records to create arrays, I mean the function NOT IN or IN - is there a build in function in active records to do that? [/quote]

Yes there is .. and it's documented in the AR section of [url="http://ellislab.com/codeigniter/user-guide/database/active_record.html"]the user guide[/url]

There was also [url="http://ellislab.com/forums/viewthread/126494/]a thread recently[/url] that talked about using the where_not_in() function in a pretty snazzy way.