Código PHP:
Ver original$result = mysql_query ("SELECT DATE_FORMAT(llegada, '%e %b %Y') as lleg, ". " DATE_FORMAT(salida, '%e %b %Y') as sal,".
" tiporeserva,".
" propiedad,".
" TO_DAYS('".$salida."') - TO_DAYS('".$llegada."') as dias ".
"from bookings ".
"where (propiedad = '".$propiedad."') ".
" AND (('".$llegada."' BETWEEN llegada AND date_sub(salida, interval +1 day)) ".
" or ('".$salida."' BETWEEN date_sub(llegada, interval -1 day) ".
" AND salida) ".
" or (llegada <= '".$llegada."' ".
" AND salida >= '".$salida."') or (llegada >= '".$llegada."' ".
" AND salida <= '".$salida."'))", $dbh);
Intenta esto