01.<?
02.include "connect.php" ;
03.?>
04.<?
05.$strSQL = "select * from employ$ order by EMPCODE";
06.$strSQL = "SELECT * FROM employ$ ORDER BY NLSSORT(EMPCODE, 'NLS_SORT = THAI_DICTIONARY')";
07.$objParse = oci_parse($objConnect, $strSQL);
08.oci_execute ($objParse,OCI_DEFAULT);
09.?>
10.<table width="600" border="1">
11.<tr>
12.<th width="91"> <div align="center">EMPCODE </div></th>
13.<th width="91"> <div align="center">FNAME </div></th>
14.<th width="91"> <div align="center">LNAME </div></th>
15.</tr>
16.<?
17.while($objResult = oci_fetch_array($objParse,OCI_BOTH))
18.{
19.?>
20.<tr>
21.<td><div align="center"><?=$objResult["EMPCODE"];?></div></td>
22.<td><?=$objResult["FNAME"];?></td>
23.<td><?=$objResult["LNAME"];?></td>
24.</tr>
25.<?
26.}
27.?>
28.</table>
29.<?
30.oci_close($objConnect);
31.?>
