01.
$strSQL
="SELECT s_class.scode, student.sid,student.stname,student.sname, student.ssname, student.sex, s_class.ccode, s_class.RCODE, room.rname'
02.
.
' FROM ( s_class INNER JOIN student ON s_class.scode = student.scode ) INNER JOIN room ON s_class.rcode = room.rcode WHERE s_class.year =CONVERT( _utf8 '
$ed_year
' USING tis620 ) AND room.rname=CONVERT( _utf8 '
$ed_class
' USING tis620 ) AND s_class.turm=CONVERT( _utf8 '
$ed_termChang
' USING tis620 ) order by s_class.scode ";
03.
04.
$objQuery
= mysql_query(
$strSQL
);
05.
$resultData
=
array
();
06.
for
(
$i
=0;
$i
<mysql_num_rows(
$objQuery
);
$i
++) {
07.
$result
= mysql_fetch_array(
$objQuery
);
08.
array_push
(
$resultData
,
$result
);
09.
}