Get maximum value of row in mysql ,using codeigniter

Question

Get maximum value of row in mysql using codeigniter.
i have following mysql data

I need to get the details based on total_payment of each student. like this

i tried code below

 $student_id_dis = $this->db->query('SELECT DISTINCT(student_id) FROM student_fees')->result_array();
 $fee_cat_id_dis = $this->db->query('SELECT DISTINCT(fee_category_id) FROM student_fees')->result_array();
 $this->db->select(['student_fees.*', 'fee_categories.fee_category_name as fee_name', 'fee_categories.amount as fee_amount']);

 $this->db->join('student', 'student_fees.student_id = student.student_id');
 $this->db->join('fee_categories', 'student_fees.fee_category_id = fee_categories.fee_categories_id');

 $where = '';

 for ($i = 0; $i < count($student_id_dis); $i++) {
    if (isset($fee_cat_id_dis[$i]['fee_category_id'])) {
        $where .='total_paid = (SELECT max(stdp.total_paid)
                                   FROM student_fees stdp
                                   WHERE stdp.fee_category_id = ' . $fee_cat_id_dis[$i]['fee_category_id'] . ')';
     }

     $this->db->where($where);

     $this->db->get('student_fees')->result_array();
      }

looking at your desire result you are searching for minimum balance — krishn Patel
– krishn Patel, Commented Mar 31, 2017 at 6:36
@knowledge.... get last payment where each student and each fee_category — noushid p
– noushid p, Commented Mar 31, 2017 at 6:45
So you can say this if student pay fee it has lowest balance right ? — krishn Patel
– krishn Patel, Commented Mar 31, 2017 at 6:48

krishn Patel · Accepted Answer · 2017-03-31 10:36:50Z

0

try this

select * from student_fees where student_fees_id in 
(select student_fees_id from 
  where total_paid =max(total_paid) group by fee_category_id)

answered Mar 31, 2017 at 10:36

krishn Patel

2,5991 gold badge22 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Get maximum value of row in mysql ,using codeigniter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related