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


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

function book_managment()
$crud = new grocery_CRUD();

$crud->set_relation_n_n('category', 'book_category', 'category', 'book_id', 'category_id', 'name');

$crud->required_fields('title', 'description' , 'category' ,'publish_year','length', 'rating');
$output = $crud->render();


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 "" same i want to do with book column here i want a self join.