I'm trying to pull enum values from database however, i'm only getting a empty selection menu. Could I get some assistance please
<?php
include('connectdb.php');
$tableName = 'firefighterinfo';
$columnName = 'status';
echo "<select name=\"$columnName\">";
$result = mysql_query("SELECT 'ENUM' FROM `fbmsdatabase`.`firefighterinfo` WHERE `status`='$columnName'") or die (mysql_error());
$row = mysql_fetch_array($result);
$enumList = explode(",", str_replace("'", "", substr($row['ENUM'], 5, (strlen($row['ENUM'])-6))));
foreach($enumList as $value)
echo '<option value="'.$value.'">'.$value.'</option>';
echo "</select>";
?>
<label for="Status">Status</label>
<?php require_once('php/enum_status.php'); ?>