require_once("script/connect.php");
$dotaz = $pdo->prepare("SELECT * FROM nominace WHERE typ='1' ORDER BY RAND() LIMIT 500");
//$dotaz = $pdo->prepare("SELECT * FROM nominace WHERE typ='1' ORDER BY 'nom_jmeno' LIMIT 500");
$dotaz->execute();
$zaznamy = $dotaz->fetchAll();
foreach ($zaznamy as $zaznam) {
if($zaznam["img"] == '') $foto = "img/male.png"; else $foto = "files/a{$zaznam['id']}.{$zaznam['img']}";
$pos=strpos($zaznam['nom_duvod'], ' ', 70);
if(strlen($zaznam['nom_duvod']) > 70 ) {
$duvod = substr($zaznam['nom_duvod'],0,$pos );
} else {
$duvod = $zaznam['nom_duvod'];
}
print "
{$zaznam['nom_jmeno']}
{$zaznam['nom_fakulta']}
$duvod ...více
";
}
?>