$title = "Vítejte v Prdeli!";
require "levak.php"?>
Koutek poezie
$q = "SELECT t.id, t.nazev, t.text, r.podpis FROM $tb_poezie t LEFT JOIN $tb_poezie_autori a ON t.id = a.id_basnicky LEFT JOIN $tb_reg r ON a.id_autor = r.id ORDER BY t.nazev";
$r = mysql_query($q) or die(err_query($q));
echo "";
$i = 0;
while ($z = mysql_fetch_assoc($r)) {
if (1 < $i) {
echo "
|
";
$i = 0;
}
echo "";
echo "" . $z['nazev'] . " ";
echo nl2br($z['text']) . " ";
echo "(" . $z['podpis'] . ")";
echo " | | ";
$i++;
}
echo "
";
require "pravak.php"?>