How to Show Data to Get Same Column Data Only?
If result is array you need try code below:
<tbody><?php$no = $this->uri->segment(3) + 1;$list_detail = $this->db->query("select * from order where invoice = '$rows->invoice'");foreach ($list_detail->result_array() as $buys) { ?> <tr> <td> <?php echo $buys['date']; ?></td> <td> <?php echo $buys['product']; ?></td> </tr> <?php $no++;}?></tbody>
There are result_array() is used and you are echo by ->(arrow) operator. You have to change the line of code.
<?php $no = $this->uri->segment(3) + 1; $list_detail = $this->db->query("SELECT * FROM order WHERE invoice = '$rows->invoice'"); foreach($list_detail->result() as $buys) //here is the changes made {?> <tr> <td><?php echo $buys->date;?></td> <td><?php echo $buys->product;?></td> </tr><?php $no++;}?> </tbody>