按字母顺序重新排列Mysql数据

Question

i have a marks table with studentid, marks, class_id, exam_id. i got marks and student_id from

$mark_query = $this->db->get_where('mark' , 
                                    array('class_id' => $class_id, 
                                           'exam_id' => $exam_id)
                );

After getting the marks and student_id i am displaying the marks with the student Name which i got it from another table with the student_id from the above query. I have a another table which have the student_id and their name.

The output is like this

Sajiv 25
Arun 35
Sonu 32
Binu 45

But i want to display the names in Ascending order.

Any ideas? I am using codeigniter.

Answer 1

Join the student table with mark table and order by student name in ascending order

    $this->db->select('students_table.name, mark.marks')
    ->from('mark')
    ->join('students_table', 'mark.student_id = students_table.id')
    ->where(['class_id' => $class_id, 'exam_id' => $exam_id])
    ->order_by('students_table.name', 'ASC')
    ->get();