php - Possible to break statement in foreach loop? -


i have 2 tables (user,user_group). user table contains

------------+-------------+------------------+ |  user_id  |  user_name  |  user_group(id)  | ------------+-------------+------------------+ 

and user_group table contains

+-----------------+-------------------+ |  user_group_id  |  user_group_name  | +-----------------+-------------------+ 

now try join them without using join query. solve problem have used double foreach() loop, no result returns. can't use break statement. how can desired result using loop? desired result be:

+-----------+-------------+-------------------+ |  user_id  |  user_name  |  user_group_name  | +-----------+-------------+-------------------+ 

what have far:

public function user_get_item() {     $this->db->select('*');     $this->db->from('users');     $results=$this->db->get()->result_array();     $this->db->select('*');     $this->db->from('user_group');     $group_data=$this->db->get()->result_array();     foreach($results $v_results)     {         foreach($group_data $v_group_data)         {             if($v_results['user_group']==$v_group_data['user_group_id'])             {                $v_results['user_group']=$v_group_data['user_group_name'];             }         }     }     return $results; } 

enter image description here

i think trying changing group id identifier group name in current row if match. so, replace:

$results['user_group']=$v_group_data['user_group_name']; 

by:

$v_results['user_group']=$v_group_data['user_group_name']; 

anyway, what's wrong joins? making sql queries faster polynomic loop.


Comments

Popular posts from this blog

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

jsf - "PropertyNotWritableException: Illegal Syntax for Set Operation" error when setting value in bean -

arrays - Algorithm to find ideal starting spot in a circle -