01.
$objDB
= mssql_select_db(
"Nitchpon"
);
02.
if
(isset(
$_POST
[
'id'
])){
03.
$id
=
$_POST
[
'id'
];
04.
$CurLevel
= iconv(
'UTF-8'
,
'TIS-620'
,
$id
);
05.
$strSQL
=
"SELECT * FROM v_studentmail WHERE student_code_status = '1' GROUP BY CurLevel CurLevel ='$CurLevel' "
;
06.
$objQuery
= mssql_query(
$strSQL
)
or
die
(
"Error Query ["
.
$strSQL
.
"]"
);
07.
$mail_to
=
''
;
08.
while
(
$objResult
= mssql_fetch_array(
$objQuery
)){
09.
$mail_to
=
$mail_to
.
$objResult
[
"Mail1"
].
'@'
.
$objResult
[
"WebMail1"
].
','
;
10.
}
11.
$new_row
[
'email'
]=
$mail_to
;
12.
$row_set
=
$new_row
;
13.
14.
echo
json_encode(
$row_set
);
15.
}