include ("header.php");
?>
$abfrage = "SELECT * FROM WeltTAB";
$erg = mysqli_query($verbindung, $abfrage);
// DatenAuswahl
$resultw = mysqli_query($verbindung, "SELECT idw, datum, titel_d, coun_d, thumb, link FROM WeltTAB $string ORDER BY datum DESC ");
$resulth = mysqli_query($verbindung, "SELECT idh, titel_d, autor FROM HaengTAB $string ORDER BY datum DESC " );
$resultb = mysqli_query($verbindung, "SELECT idb, datum, titel_d, thumb, link FROM BilderTAB $string ORDER BY datum DESC " );
// $resultni = mysqli_query( "SELECT idn, titel_d, link FROM NewsTAB WHERE typ = 'Info' ORDER BY datum DESC LIMIT 2" );
// $resultne = mysqli_query( "SELECT idn, titel_d, link FROM NewsTAB WHERE typ = 'Ereignis' ORDER BY datum DESC LIMIT 2" );
$resultnk = mysqli_query($verbindung, "SELECT idn, titel_d, link FROM NewsTAB WHERE typ = 'Kultur' ORDER BY datum DESC " );
$resultnn = mysqli_query($verbindung, "SELECT idn, titel_d, link FROM NewsTAB WHERE typ = 'News' ORDER BY datum DESC " );
?>
|
while ($roww = mysqli_fetch_row($resultw)) { ?>
if ($roww[5]== "") {
print " ";
}
else {
print " ";
} ?> |
print "$roww[3]"; ?> print "$roww[2]"; ?> print "$roww[1]"; ?>
|
} ?>
|
|
while ($rowh = mysqli_fetch_row( $resulth )) { ?>
» echo "$rowh[1]"; ?> ( echo "$rowh[2]";?>)
} ?> |
|
while ($rowb = mysqli_fetch_row( $resultb )) { ?>
echo " "; ?> |
echo "$rowb[2]"; ?> echo "$rowb[1]"; ?> |
} ?>
| |
$resultbook = mysqli_query($verbindung,"SELECT titel, autor, ansin FROM buch_fb ORDER BY id DESC ");
while ($row = mysqli_fetch_row($resultbook))
{ echo " » $row[1] » $row[0]"; } ?>
|
|