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