01.<table width="600" border="0" align="left">
02.<tr>
03.<td width="150" align="right" class="style1"><font color="#000000">รายวิชา:</font></td>
04. <td width="450" height="9" class="style1"><?
05.include ("connect_db.php");
06.$strSQL = "SELECT DISTINCT AVSREG.COURSE.COURSENAME,AVSREG.COURSE.COURSEID FROM AVSREG.COURSE ";
07.$objParse = oci_parse ($objConnect, $strSQL);
08.oci_execute ($objParse,OCI_DEFAULT);
09.?>
10. <select name="select2" id="select2">
11. <option value="["COURSEID"]" > ---เลือก--- </option>
12. <?
13.while($objResult = oci_fetch_array($objParse,OCI_BOTH))
14.{
15.?>
16. <option value="<?=$objResult["COURSEID"];?>">
17. <?=$objResult["COURSENAME"];?>
18. </option>
19. <?
20.}
21.?>
22. <?
23.oci_close($objConnect);
24.?>
25. </select></td>
26. </tr>
27. </table>
