<?php

$link = mysql_connect("localhost", "skorvanek13", "1234567890")
        or die("Could not connect");

print "Pripojenie k databazi prebehlo uspesne.\n";

mysql_select_db("skorvanek13") or die("Couldn't select db");

$query = "SELECT zamestnanci.meno, zamestnanci.priezvisko, zamestnanci.dat_narodenia, typ_zamestnania.zamestnanie
    FROM zamestnanci
    LEFT OUTER JOIN typ_zamestnania
    ON typ_zamestnania.id = zamestnanci.typ_id";
$result = mysql_query($query) or die(mysql_error($link));

print "<table border=\"1 \">\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
    print "\t<tr>\n";
    foreach ($line as $col_value) {
        print "\t\t<td>$col_value</td>\n";
    }
    print "\t</tr>\n";
    
    $vysledky = $line;
}
print "</table>\n";
mysql_free_result($result);
mysql_close($link);

var_dump($vysledky);

?>