Codeigniter - How to Join City Country State by concatenate two fields in Sql :: - Stack Of Codes

Breaking

Thursday, 14 December 2017

Codeigniter - How to Join City Country State by concatenate two fields in Sql ::

Codeigniter - How to Join City Country State by concatenate two fields in Sql ::

$this->db->select(" CONCAT(c.name,'-',co.code) as id,CONCAT(c.name,' ,',s.name,' ,',co.name) as text",FALSE);

$this->db->from("city c");
$this->db->join('state s', 's.id=c.state_id', 'left');
$this->db->join('countries co', 'co.id=s.country_id', 'left');
$this->db->where('c.status','Y');
$this->db->order_by('c.id', 'ASC');

$query = $this->db->get();

No comments:

Post a Comment

Topics

PHP (27) CodeIgniter (22) SQL (4) Facebook (3) HTML (3) Blogger (2) Constructor (2) Destructor (2) Google (2) Aadhaar (1) Agent (1) Browser (1) CSS (1) Cakephp (1) Constants (1) How to (1) India (1) Ip address (1) JS (1) Jquery (1) Meta Tags (1) Robots (1) Scraping Data (1) escape_str (1) htaccess (1) iS mobile (1) javascript (1) mysqli (1)