Consulta rango entre 2 fechas!!!...

[walterdevel]

Tus fechas están mal formateadas, fijate:

BETWEEN '08/02/2011' AND '08/05/2011'

El formato debe ser 2011-08-02.

Te paso una función para solucionarlo:

Código PHP:

function js2PhpTime($jsdate){
  if(preg_match('@(\d+)/(\d+)/(\d+)\s+(\d+):(\d+)@', $jsdate, $matches)==1){
    $ret = mktime($matches[4], $matches[5], 0, $matches[1], $matches[2], $matches[3]);
    //echo $matches[4] ."-". $matches[5] ."-". 0  ."-". $matches[1] ."-". $matches[2] ."-". $matches[3];
  }else if(preg_match('@(\d+)/(\d+)/(\d+)@', $jsdate, $matches)==1){
    $ret = mktime(0, 0, 0, $matches[1], $matches[2], $matches[3]);
    //echo 0 ."-". 0 ."-". 0 ."-". $matches[1] ."-". $matches[2] ."-". $matches[3];
  }
  return $ret;
}
 
echo date("Y-m-d", js2PhpTime('08/02/2011'));
 

( obtenida del wcalendar )