2 then in an case statement mysql

[helenp]

Hi I have this select:
(select
(CASE WHEN ('$llegada' BETWEEN baja_inicio AND baja_fin and '$salida' BETWEEN baja_inicio AND baja_fin)
THEN sum(precio_baja) * (TO_DAYS('$salida') - TO_DAYS('$llegada')) ELSE NULL END) as price
(CASE WHEN etc

As you can see the days between is * by the price in precio_baja column,

What I want to do is to use the same to_days to get how many days there are without doing another select.

Something like this:
THEN sum(precio_baja) * (TO_DAYS('$salida') - TO_DAYS('$llegada') as days) AS price ELSE NULL END),

THEN sum(precio_baja) * (TO_DAYS('$salida') - TO_DAYS('$llegada')) AS price AND (TO_DAYS('$salida') - TO_DAYS('$llegada')) as days ELSE NULL END),

So far only gets errors

[coopster]

What errors are you receiving?