• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to make self join in GroceryCRUD

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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.