Welcome Guest, Not a member yet? Register   Sign In
get result from join same table join
#2

PHP Code:
$this->db->select('sub.*, h1.status_name as h1_status_name, h2.status_name as h2_status_name'); 

//in view:
PHP Code:
<tr>
 <td>1</td>
<
td>Hibah 1</td>
 <td><?php echo $sub_set_detail[0]->h1_amount?></td>
<td><?php echo $sub_set_detail[0]->h1_status_name?></td>
<td><?php echo $sub_set_detail[0]->h1_date?></td>
</tr>

<tr>
 <td>1</td>
<td>Hibah 1</td>
 <td><?php echo $sub_set_detail[0]->h2_amount?></td>
<td><?php echo $sub_set_detail[0]->h2_status_name?></td>
<td><?php echo $sub_set_detail[0]->h2_date?></td>
</tr> 
Reply


Messages In This Thread
RE: get result from join same table join - by neuron - 10-10-2017, 08:09 AM



Theme © iAndrew 2016 - Forum software by © MyBB