foreach() inside while()

[crobinson42]

Hello everyone1 I'm having a problem and I assume it's because I can't figure out a more clever way to write this segment of code.



//make array of shifts between dates
$query1="SELECT * FROM schedule_shift WHERE post='$post' AND start_date>='$start' AND start_date<='$end'";
$result1=mysqli_query($dbc, $query1);
if(mysqli_num_rows($result1) == '0'){ $shifts[]='1'; }
while($shift=mysqli_fetch_assoc($result1)){ $shifts[]=$shift; }

echo '<tr><td>'.$row['name'].'</td>';

while(date('Y-m-d',$sd) <= date('Y-m-d',$ed)){
$d=date('Y-m-d',$sd);
echo '<td>'.date('Y-m-d',$sd).'<hr>';

foreach($shifts as $shift){
if($shift['start_date'] == $d){
echo $shift['officer_name'].'<br>';
echo $shift['start'].'-'.$shift['end'].'<br>';
}
echo '</td>';
}

$sd= strtotime("+1 Day", $sd);
}

Any help on getting this to work or a more efficient way of writing it?