Use database connection in a helper

[eluser]Unknown[/eluser]
Hello everyone,

I'm relatively new to CodeIgniter, and I must say I love it.

1 problem. I want to use a database connection and a query in a helper. How do I do this ?

Thanks a lot

[eluser]bitist[/eluser]
Here is an example how can you count all users.

Code:

$CI =& get_instance();
$CI->db->count_all_results('users');

[eluser]Unknown[/eluser]
Thanks! I thought I've read this somewhere, but I didn't remember where that was