Comop te dijeron te falta el alias a retornar
Código PHP:
Ver original$query = '
SELECT
CASE mes
when "1" then "January"
when "2" then "February"
when "3" then "March"
when "4" then "April"
when "5" then "May"
when "6" then "June"
when "7" then "July"
when "8" then "August"
when "9" then "September"
when "10" then "October"
when "11" then "November"
when "12" then "December"
END as mesletra
FROM mitabla ORDER BY mes
';
if ( $resultado = $mysqli->query($query) {
while($fila = $resultado->fetch_array()) {
echo "<p>" . $fila["mesletra"] . "</p>";
}
}