<?php

$user = 'root';
$password = '';
$database = 'stomatologia';

mysql_connect(localhost,$user,$password);
@mysql_select_db($database) or die("Nie znaleziono bazy danych");

$result = mysql_query("SELECT * FROM rejestracje WHERE DATA=$data");
$num = mysql_num_rows($result);


echo '<p>Wybrana data: '.$data.'</p>';

$time ='08:00:00';
$timestamp = strtotime($time);
$godz = mktime(8, 0, 0, date('n', $timestamp), date('j', $timestamp), date('Y', $timestamp));
$time = date('H:i', $godz);

echo '<table>';
for($i=0;$i<20;$i++){
    echo '<tr><td ';
    $czy = FALSE;
    $time = date('H:i', $godz);
    for($j=0;$j<$num;$j++){
        if(mysql_result($result,$j,"GODZINA")==$time){
            $czy = TRUE;
        }
    }
    if($czy)
        echo 'bgcolor="red"><p>'.$time.'</p></tr></td>';
    else
        echo 'bgcolor="green"><p>'.$time.'</p></tr></td>';
    $godz += 1800;
}


echo '</table>'
?>