PHP Kod:
<?php
$personel = $_SESSION['ekp'];
$randevuTarih=date("Y-m-d");
$query_saatler = "SELECT * FROM zaman ORDER BY saat ASC";
$saatler = mysqli_query($con,$query_saatler);
while ($row_saatler = mysqli_fetch_assoc($saatler)) {
$sel_query="Select * from randevuzaman WHERE ekip = $personel and tarih like '%$randevuTarih%' and saatid = '".$row_saatler['saatid']."' ";
$result = mysqli_query($con,$sel_query);
$row = mysqli_fetch_assoc($result);
$rsaat = date_create($row_saatler["saat"]); $rsaat1 = date_format($rsaat,"H:i:s");
echo $rsaat1 ;
echo " ".$row["kayitID"]."";
echo " ".$row["adisoyadi"]."";
echo "<br>";
}
?>