⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

How to select simple join results? (Relations)



amkosys

amkosys
  • profile picture
  • Member

Posted 04 April 2012 - 17:46 PM

I have 2 tables which is like below.

1) user
=======
id
login_id
password


2) user_info
===========
id
id_user
first_name
last_name
email
contact_no


I want result from above 2 table by joining them.,.

Here is my code, which is not working..


$crud->set_table('user');
$crud->set_relation('id','user_info','id_user');
$crud->columns('login_id','first_name','last_name','email','contact_no');

web-johnny

web-johnny
  • profile picture
  • Administrator
  • 1,166 posts

Posted 09 April 2012 - 10:12 AM

This is a 1-1 relation that grocery CRUD still doesn't support. I am sorry.