Welcome Guest, Not a member yet? Register   Sign In
database problem. Help me!
#1

[eluser]java[/eluser]
I want to get value of 1 table via id of 2 table. I have tried to use join() query command to solve but it not effective and display this error:
Quote:An Error Was Encountered
Unable to load the requested language file: language/db_lang.php
This is my code:
Code:
$this->db->select('SoBaoDanh,HoTen,NgaySinh,DiaChi,ChieuCao,CanNang,VongNguc,VongEo,VongMong');
        //$this->db->select('Ten');// field name of another table
        $this->db->from('hoahau');
        $this->db->join('thanhpho','ThanhPhoID = ThanhPhoID');// join 2 table
        $this->db->where('Enable','1');
        $this->db->orderby('HoahauID desc');
How can i get the value of a table which have related with another table? Tell me please..


Messages In This Thread
database problem. Help me! - by El Forum - 06-22-2007, 03:11 AM
database problem. Help me! - by El Forum - 06-22-2007, 03:19 AM
database problem. Help me! - by El Forum - 06-22-2007, 03:35 AM
database problem. Help me! - by El Forum - 06-22-2007, 04:30 AM
database problem. Help me! - by El Forum - 04-22-2008, 11:44 AM



Theme © iAndrew 2016 - Forum software by © MyBB