<?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 rok");

$num=mysql_numrows($result);
?>
<h2>Wyswietlanie</h2>
<form action="pokaz.php" method="post">
    Rok:<select name="rok">
    <?php
        $i=0;
        while ($i < $num) {
            $variable=mysql_result($result,$i,"Rok");
            echo '<option>'.$variable.'</option>';
            $i++;
        }
    ?>
        </select>
    Miesiac:<select name="miesiac">
    <?php
        $i=0;
        $result=mysql_query("SELECT * FROM miesiac");
        $num=mysql_numrows($result);
        while ($i < $num) {
            $variable=mysql_result($result,$i,"miesiac");
            echo '<option>'.$variable.'</option>';
            $i++;
        }
    ?>
        </select>
    Dzien:<select name="dzien">
    <?php
        $i=0;
        $result=mysql_query("SELECT * FROM dzien");
        $num=mysql_numrows($result);
        while ($i < $num) {
            $variable=mysql_result($result,$i,"Dzien");
            echo '<option>'.$variable.'</option>';
            $i++;
        }
    ?>
        </select>
    Godzina:<select name="godzina">
    <?php
        $i=0;
        $result=mysql_query("SELECT * FROM godzina");
        $num=mysql_numrows($result);
        while ($i < $num) {
            $variable=mysql_result($result,$i,"godzina");
            echo '<option>'.$variable.'</option>';
            $i++;
        }
    ?>
        </select>
</form>