<select name="houseid" size="1">
<?php
require_once 'functions.php';
connectDb();
$result = mysql_query("SELECT HouseID FROM houseinfo WHERE status=0" );
while($colum=mysql_fetch_array($result)){
?>
<option value="<?php echo $colum["HouseID"];?>"><?php echo $colum["HouseID"];?></option>;
<?php
}
?>
</select>
<?php
require_once 'functions.php';
connectDb();
$result = mysql_query("SELECT HouseID FROM houseinfo WHERE status=0" );
while($colum=mysql_fetch_array($result)){
?>
<option value="<?php echo $colum["HouseID"];?>"><?php echo $colum["HouseID"];?></option>;
<?php
}
?>
</select>
Select Language