如何在一个查询中编写asc [关闭]

Question

I wrote this query but did not work there is problem in writing asc and follow each other .

How I can solve this problem ?

$q = "SELECT * FROM coe_courses LEFT JOIN equal_coe ON
 equal_coe.course_number=coe_courses.course_number 
LEFT JOIN student_record ON coe_courses.course_number=
student_record.course_number order by student_record.course_number asc AND student_record.id=". $_SESSION['user_id'];

Answer 1

Your SQL query needs to be rearranged to use a WHERE clause, like this:

$q = "SELECT * FROM coe_courses 
      LEFT JOIN equal_coe ON equal_coe.course_number=coe_courses.course_number 
      LEFT JOIN student_record ON coe_courses.course_number=student_record.course_number 
      WHERE student_record.id=". $_SESSION['user_id'] ."
      order by student_record.course_number asc";