populating a drop down box using values in a table

[mishuk]

hi i am working on populating a drop down menu with a select statement and have got so far.

The drop down box is populated with value however the value are null.  Can anyone help?

$query="select distinct(house_type) from tbl_accommodation";
$stmt = ociparse($conn, $query);
ociexecute($stmt);

echo '<select name="house_type">';
echo '<option value = "-1">Select:</option>';

while($row=ocifetch($stmt)) {
echo $row;
		echo '<option value=' . $row['house_type'] . '>' . $row['house_type'] . '</option>';
	}
		echo '</select>';

[gluck]

print the result set and see what is returned from database.

[Feenix566]

Oracle returns all its results in CAPS. So change it to $row['HOUSE_TYPE'] and you should get the data.

 

Also, start programming with your error reporting set to E_ALL so you can see notices about undefined indexes in the future.