I have a function that reads from a database and list to a webpage the results. What I want is to have the selected item on a list box show when a PHP variable is found, here is my code I have so far:
<?php
while ($row = db2_fetch_assoc($stmt)){
$WHMARK = $row['WHMARK'];
$WHHOTEL = $row['WHHOTEL'];
$WHSTATUS = $row['WHSTATUS'];
if ($WHSTATUS == 1)
{
$Status = "Active";
}
else{
$Status = "In-Active";
}
echo '<tr>';
echo '<td>'.$WHMARK.'</td>';
echo '<td>'.$WHHOTEL.'</td>';
echo '<td>'.$Status.'</td>';
echo '<td>';
echo '<label>';
echo ' <select name="hotelActive" id="hotelActive">';
echo ' <option value="1"' <?php if($WHSTATUS == 1) ? 'selected="selected">';?>' echo '>Active</option>';
echo ' <option value="0"' <?php if($WHSTATUS == 0) ? 'selected="selected">';?>' echo '>In-Active</option>';
echo ' </select>';
echo '</label>';
echo '</td>';
echo '</tr>';
}
?>
I need option value 1 selected if the variable '$Status' is 1 and option value 2 selected if the variable '$Status' is 2. This is PHP embedded in a HTML table.