include '../../Nav/Top/topbar_ausstellung.php'; ?>
include '../../Nav/Navmenu/menubar_ausstellungen.php'; ?>




"; //echo "    Ausstellungen"; // Verbindung mit DB fuer Linkeintragungen anzeigen $sql = "SELECT * FROM links.ausstell_db order by timestamp DESC"; $result = mysql_query($sql); $num = mysql_num_rows($result); for ($i = 0; $i < $num; $i++) { $row = mysql_fetch_array($result); $owner= $row['owner_id']; $pfad= $row['pfad']; $id_austell=$row['id_ausstell']; //echo "---$pfad--->$id_austell<--"; $sql_pic= "Select pic_name From links.ausstell_pic_db where id_ausstell='$id_austell' order by timestamp DESC "; $row_pic = mysql_query($sql_pic); $pic_anzahl= mysql_num_rows($row_pic); $pic_name = mysql_fetch_array($row_pic); //echo "---PIC:$pic_name[0]---
"; $sql1= "Select nickname From Bilder.benutzerdaten where owner_id='$owner'"; $row_1 = mysql_query($sql1); $user= mysql_fetch_row($row_1); //echo $user[0]; $tstamp= $row['timestamp']; $datum = date("d.m.Y",$tstamp); // timestamp in datum $uhrzeit = date("H:i:s",$tstamp);// Timestamp in Uhrzeit echo '
Tilel: '.$row['titel'].'
Ort: '.$row['ort'].'
Wann: '.$row['ausdatum'].'
Info: '.$row['kommentar'].'
Link: '.$row['link'].'
eingestellt: '.$datum.' '." - ".' '.$uhrzeit.'
';?> "; //echo "---$pic_anzahl---"; // $tname="thumb_$pic_name[0]"; // $name="$pic_name[0]"; //$te="test mit pic 21383915166_0.jpg"; // echo"$name
"; // echo"$pfad
"; if ($pic_anzahl>="2") { //echo"mehr Bilder"; $tname="thumb_$pic_name[0]"; $z1=1; $result2 = mysql_query("Select pic_name From links.ausstell_pic_db where id_ausstell='$id_austell' order by timestamp DESC" ); while($pic_name2 = mysql_fetch_array($result2)) { $name2="$pic_name2[0]"; //echo "-$r-"; if ($z1==1) { ?> "> "> "; } } else { $tname="thumb_$pic_name[0]"; $name="$pic_name[0]"; //echo"ein Bild"; ?> "> "; } }?>
'; echo"
"; ?>


include '../../Footer/footer.php'; ?>