• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.