PHP get all dates in a range from sql

While there probably is a pure MySQL solution, here's a PHP alternative using the DateTime class. Set $start_date and $end_date to the values from your database, and let it run! The loop automatically increments the day by 1 until you reach your final date.

$start_date = "2017-03-27";
$end_date = "2017-03-30";

$start = new DateTime($start_date);
$end = new DateTime($end_date);

while ($start < $end) {
    echo $start->format("Y-m-d")."\n";
    $start->modify("+1 day");
}

Output:

2017-03-27
2017-03-28
2017-03-29

Live demo

you just need to use 2 loops. 1 to fetch your result the other to check the condition and echo. first loop this is if you use PDO then the code is correct ,otherwise if you use mysql old way then it will be "while ($row = mysql_fetch_assoc($result)) "

$i=0;
    while ($row = $query->fetch(PDO::FETCH_ASSOC)){
        $date1=$row[$i]['datein'];
        $date2=$row[$i]['dateout'];
       // we check that entry date is not bigger then the exit day
        IF ($date1 > $date2){
            echo 'error in date entry date bigger then exit date';
            //continue will bypass the next loop and go to the next row
            continue; 
            }   
           while ($date1 != $date2){
           echo $date1;
           $date1=date('Y-m-D',strtotime($date1 . ' + 1 day);
           }
$i++;    
}

hope it can help you