丁才軒討論站

代碼: 選擇全部

  $sql  = "SELECT S.id,S.type,R.sid,S.rec_date,T.name,S.upload_by ";
  $sql .= "FROM (soa_register R INNER JOIN soa_student T ON R.sid=T.SID) LEFT OUTER JOIN soa_survey S ";
  $sql .= "ON (R.sid = S.sid AND r.syear = s.syear  AND r.semester = s.semester  AND s.type = '$type') ";
  $sql .= "WHERE  r.syear = $syear  AND r.semester = $semester AND teacher_id IN ('$teacher_id','999999') "; 
  $sql .= "AND (rec_date IS NULL OR (rec_date BETWEEN '$sdate' AND '$edate') )
ORDER BY R.sid ";