1

 SELECT DISTINCT car_no FROM tbl_input

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

  <select name="Car_no" size="1">
       <option value="">----- กรุณาเลือก -----</option>
 <?php
     include("db.php");
     $str = "SELECT DISTINCT car_no FROM tbl_input";
     $rd = mysql_query($str) or die(mysql_error());
     $num = mysql_num_rows($rd);
     if ($num > 0)
     {
       while ($row = mysql_fetch_array($rd))
       {
         echo "<option value ='" . $row["car_no"] . "'>" .$row["car_no"] . "</option>";
       }  /*end while */
     }  /* end if*/
     ?>
       </select>