";
// Picture Name, gets Picture
for ($i = 0; $i < ($rows+1) ; $i++) {
$tale=mysql_result($rsTest, $i, 5); // tale id
$nick=mysql_result($rsTest, $i, 1); // nick
$posting=mysql_result($rsTest, $i, 3); // posting text
if ($tale==2) {
$picture ="../gafik/PinkShoek.jpg";
$picDescr="pink shoe by Jose Manuel Diaz";
}
elseif ($tale==1) {
$picture ="../gafik/Kristallkugelkk.jpg";
$picDescr="crystal ball by Danny Smythe";
}
elseif ($tale==3) {
$picture ="../gafik/schwaene.jpg";
$picDescr="Schwäne by Frank Schöttke";
}
elseif ($tale==4) {
$picture ="../gafik/Froschbaeume.jpg";
$picDescr="Fröschbäume by Frank Schöttke";
}
elseif ($tale==5) {
$picture ="../gafik/redrosebudk.jpg";
$picDescr="red rosebud by Baloncici";
}
elseif ($tale==6) {
$picture ="../gafik/anruechig.jpg";
$picDescr="anrüchig by Yvonne Bogdanski";
}
elseif ($tale==7) {
$picture ="../gafik/stab.jpg";
$picDescr="stab by Yevgeniya Ponomareva";
}
elseif ($tale==8) {
$picture ="../gafik/blood.jpg";
$picDescr="blood by Maria Boytunova";
}
else {
$picture="../gafik/notale.jpg";
}
if (!empty($tale)) {
$taleTitle=taleTitle($tale);
}
else {
$taleTitle="";
}
if (!empty($tale)) {
$talePage=talePage($tale);
}
//
echo "
";
if (empty($tale)) {
echo "Zu diesem Beitrag wurde kein Märchen ausgewählt";
}
else {
echo "Eine Interpretation zum Märchen ".$taleTitle."";
}
echo "
";
echo "
von: ".$nick.
"
";
echo "
".$posting."
";
echo "
";
}
echo "
";
}
else {
echo "Diese Seite wird überarbeitet.";
}
function taleTitle($id) {
$rsTale=mysql_query("SELECT * FROM tbltales WHERE (tale_id = '".$id."')");
$taleTitle=mysql_result($rsTale, 0, 1);
return $taleTitle;
}
function talePage($id) {
$rsTale=mysql_query("SELECT * FROM tbltales WHERE (tale_id = '".$id."')");
$talePage=mysql_result($rsTale, 0, 3);
return $talePage;
}
?>
