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

(10-10-2017, 08:09 AM)neuron Wrote:
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> 

Its work bro. Thank you so much!
This is me. JK not me.
Reply


Messages In This Thread
RE: get result from join same table join - by falcon812311 - 10-10-2017, 07:01 PM



Theme © iAndrew 2016 - Forum software by © MyBB