A general rule in SQL is to only call what you need to; and try to avoid using the *
selector as it will grab all columns in whatever order they are in the table.
Where this comes into play when you want to display it; as you are calling the columns by their index number.
$roomtype = "SELECT DISTINCT RoomType, RoomRate FROM roomtypes";
This will get you only what you are using, and then you would know exactly what column names (RoomType, RoomRate) are at what indexes (0, 1)