$sql="select * from my_table where expiry date>='".date('d/m/Y')."' and date<='".date('d/m/Y', strtotime('+5 day'))."'";