Changeset 673
- Timestamp:
- Dec 11, 2014 2:20:27 PM (10 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
pro-violet-viettel/sourcecode/application/modules/frontend/models/user_model.php
r668 r673 135 135 public function get_user_by_id($us_id) { 136 136 $this->db->query ( 'UNLOCK TABLES' ); 137 $this->db->select ( '*' )->from ( 'tbluser' )->join('tblservicepackage','tbluser.p_id=tblservicepackage.p_id' )->where ( 'tbluser.us_id', $us_id );137 $this->db->select ( '*' )->from ( 'tbluser' )->join('tblservicepackage','tbluser.p_id=tblservicepackage.p_id','left')->where ( 'tbluser.us_id', $us_id ); 138 138 $query = $this->db->get (); 139 139 if ($query->num_rows () > 0) {
Note: See TracChangeset
for help on using the changeset viewer.