php下拉菜单读取数据库

 

$result_house = mysql_query("select * from house");

<select name='house_id'>
    <?php
    while($house = mysql_fetch_array($result_house)){
        echo "<option "."value='$house[\'house_id\']'".">".$house['house_name']."</option>";
    }
    ?>

哪里有问题?

value值该怎么写?

 

  while($house = mysql_fetch_array($result_house)){
        echo "<option value='".$house['house_id']."'>".$house['house_name']."</option>";
    }