CodeIgniter + Doctrine = Me Going Crazy

[eluser]DigitalSkye[/eluser]
extend the doctrine_table class (name must match the doctrine_record). Put your custom functions in the doctrine_table.

user.php

Code:

Class User extends Doctrine_Record {
/* table definition code here */
}

user_table.php

Code:

Class UserTable extends Doctrine_Table {

function get_something()
{
  /* run query, return result object, array, scalar -- depending on what you are doing with it */
}
}

in your controller

Code:

$something = UserTable::get_something();

Edit: This allows you to keep your controllers thin and you can call the doctrine_table function from anywhere in your app.

http://www.doctrine-project.org/projects...w/en#table