Type, 5, -1) );
array_push($hotels_array, "'".strtoupper($hotel_to_add)."'");
$hotels_list = implode(",", $hotels_array);
$sql_hotel = "alter table starwood modify column hotel enum(" . $hotels_list . ")";
$result_hotel = mysql_query($sql_hotel);
echo "
Item Saved
Close Window";
echo mysql_error() . "
";
break;
default:
// display screen to get prelim block info
$sql_hotels_list = "show columns from starwood like 'hotel'";
$result_hotel_list = mysql_query($sql_hotels_list);
$table_info = mysql_fetch_object($result_hotel_list);
$hotels = str_replace(",", "
", str_replace("'", "", substr($table_info->Type, 5, -1)) );
?>