+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=22)
+--- Thread: how to make self join in GroceryCRUD (/showthread.php?tid=55643)
how to make self join in GroceryCRUD - El Forum - 11-05-2012
[eluser]webmasterminds[/eluser]
Hi..!
I have a table "books" and a column "books.tags"
i want to make a self join so tags should b display by click on the field
as it happens in "set_relation_n_n"
here is my query
Controller:
function book_managment()
{
$crud = new grocery_CRUD();
$crud->set_theme('datatables');
$crud->set_table('books');
$crud->set_relation_n_n('category', 'book_category', 'category', 'book_id', 'category_id', 'name');
$crud->unset_columns('tags','description');
$crud->required_fields('title', 'description' , 'category' ,'publish_year','length', 'rating');
$crud->set_field_upload('file','assets/uploads/files');
$output = $crud->render();
$this->output($output);
}
as i define set_relation_n_n so when i go to add a new record and click on "name" column of category table it show me all "category.name" same i want to do with book column here i want a self join.