รบกวนช่วยดูโค้ดให้หน่อยค่ะ ต้องการดึงข้อมูลจากMysql ในตารางตัวเดียวกัน มาสร้าง Dropdown หลายๆช่อง แบบวนลูป

# ติดต่อฐานข้อมูล
include("../database.php");

$sql = "SELECT distinct data FROM room  order by data ";
$result=mysql_query($sql) or die("Select error : ".mysql_error());
$num = mysql_num_rows($result);
$arr_data = array();
$i=0; 
while($i<$num){ 
	$row = mysql_fetch_array($result); 
	$data = $row['data']; 
	$i++;   
	array_push($arr_data, $data);
} 

<script type="text/javascript">
$(document).ready(function(){
	var str_data ="<?php echo implode(",", $arr_data);?>";
	var arr_data = str_data.split(",");

	$("#data").autocomplete( arr_data );

})
</script>

$sql="SELECT * FROM room WHERE datepay = '$datepay' and data = '' ORDER  BY billno;";
$result=mysql_query($sql);
$dbarr=mysql_fetch_array($result);
$totalrecord=mysql_num_rows($result);

echo "<form name='post' method='post' action='edit3.php' enctype='multipart/form-data' target='_self'>\n";

for($i=0; $i<$totalrecord; $i++) {
  $j=$i+1;
  echo "<tr>";
  echo "<td align='center' class='atnoon'>";
  echo "&nbsp;<input class='catnoon' type='text'  id='data' name='data[]' size=15 value='".mysql_result($result,$i,"data")."'>&nbsp;</td>";
  echo "<input type='hidden' name='id[]' value='".mysql_result($result,$i,"id")."'>";
  echo "<td align='center' class='atnoon'>";
  echo "</tr>";
}

echo "</form>";