• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Joining Multiple database problem :(

#11
[eluser]saidai jagan[/eluser]
Thanks man , i used it but it does not working Smile Simple but a tough one , right ?

#12
[eluser]xwero[/eluser]
The code is clean now, it's a long time ago i used native database functions Smile

#13
[eluser]saidai jagan[/eluser]
ok , leave it. I will try it in another way Sad . Once again thanks for u r help. this forum rocks. if u kno some thing just post in this forum.
In future we ll have this facility to connect two db's .
Thanks.

#14
[eluser]xwero[/eluser]
I just tested this
Code:
function multi()
    {
        $query = $this->db->query('select a.id, a.email from test.users a left join test2.users b on b.id = a.id');

        return $query->result();
    }
And binding an active database to a connection has no effect on querying 2 databases at the same time. So we are back to the permissions.

#15
[eluser]saidai jagan[/eluser]
Thanks man !!!.

keep in buisness.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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