从数据库中选取数据形成select标签

添加文章时用代码如下：

        <select name="NClass" id="NClass" class="sel">

         <?php

		  $querySel = "select * from nclass";

		  $result_sub = mysql_query($querySel) or die(mysql_error());

		  $i = 0;

		  while($row_sub=mysql_fetch_array($result_sub))

			{

				$result_show[$i] = $row_sub;

				echo "<option value='". $result_show[$i]['ID'] ."'>". $result_show[$i]['ClassName'] ."</option>";

				$i++;

 			}

		 ?>

        </select>

编辑文章时用如下代码：

       <select name="HotelID" id="HotelID" class="sel">

         <?php

		  $querySel = "select * from hotel where AddUser=".$_SESSION['UserID'];

		  $result_sub = mysql_query($querySel) or die(mysql_error());

		  $i = 0;

		  while($row_sub=mysql_fetch_array($result_sub))

			{

				$result_show[$i] = $row_sub;

				if ($row['HotelID'] == $result_show[$i]['ID']) $sel_c = "selected";

				echo "<option ".$sel_c." value='". $result_show[$i]['ID'] ."'>". $result_show[$i]['HName'] ."</option>";

				$sel_c = "";

				$i++;

 			}

		 ?>

        </select>