โค้ด: เลือกทั้งหมด
$sql_ary = array(
'SELECT' => 'u.user_id, u.group_id as default_group, u.username, u.username_clean, u.user_colour, u.user_type, u.user_rank, u.user_posts, u.user_allow_pm, g.group_id ,g.group_name',
'FROM' => array(
USER_GROUP_TABLE => 'ug', //ดึงข้อมูลกลุ่มผู้ใช้งาน
),
'LEFT_JOIN' => array(
array(
'FROM' => array(USERS_TABLE => 'u'), //ดึงข้อมูลผู้ใช้งาน
'ON' => 'ug.user_id = u.user_id',
),
array(
'FROM' => array(GROUPS_TABLE => 'g'),
'ON' => 'ug.group_id = g.group_id',
),
),
'WHERE' => $this->db->sql_in_set('ug.user_id', $this->user->data['user_id'], false, true) . ' AND ug.user_pending = 0',
'ORDER_BY' => 'u.username_clean ASC',
);
$sq = $this->db->sql_build_query('SELECT', $sql_ary);
$res = $this->db->sql_query($sq);