CodeIgniter Forums

Full Version: how to make self join in GroceryCRUD
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

[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.