01.<?php
02.$servername = "serverpl2";
03.$databasename1 = "PO";
04.$user = "itmanager";
05.$pass = "memory";
06.$connection_string ="DRIVER={SQL Server};SERVER=$servername;DATABASE=$databasename2;AutoTranslate=no;charsets=utf-8";
07.$CnStyle = odbc_connect($connection_string2,$user, $pass) or die ("?เชื่อม?ต่อ server ไม่?ได้?");
08.echo"<p class=\"phead\">กรุณาเลือกข้อมูลที่ท่านต้องการ</p>";
09.echo"<form name=\"frmserch\" method=post action=\"showdetail.php\" target=\"chklab\">";
10.echo"<table width=\"570\" cellpadding=\"1\" cellspacing=\"1\">";
11.$sqlstr=utf8_decode($sqlstr);
12.$sqlstr="Select Distinct Style From Job Order by Style";
13.if (@!$result = odbc_exec($CnStyle, $sqlstr)){exit("ไม่สามารถติดต่อฐานข้อมูลได้");}
14.$i=0;
15.echo"<tr bgcolor=\"#6DBFFF\">";
16.echo"<td>";
17.echo" Style : </td><td>";
18.echo" <select name=\"Style\" size=1>";
19.echo"<option value=\"\"> </option>";
20.while($row2=odbc_fetch_array($result)){
21. $i++;
22. echo"<option value=\"".$row2["Style"]."\">".$row2["Style"]."</option>";
23.}
24.echo"</select> ";
25.echo"</td></tr>";
26.
27.?>
