include("params.php");
$rubrikid=$_GET['rubrikid'];
$id=$_GET['id'];
//------------------------------------------------------------------rubrik farbe
$abfrage = "SELECT name, color, amazon FROM rubrik WHERE id=$rubrikid";
$rs = @mysql_query($abfrage, $con);
list($rubrikname, $color, $amazon) = @mysql_fetch_row($rs);
//------------------------------------------------------------------artikel
$abfrage = "SELECT id, name, einleitung, subhead0, subhead1, subhead2, ";
$abfrage .= "subhead3, subhead4, ";
$abfrage .= "text0, text1, text2, text3, text4, text5, ";
$abfrage .= "bildname, bildanzahl, ";
$abfrage .= "bildtext0, bildtext1, bildtext2, bildtext3, bildtext4, description, keywords ";
$abfrage .= "FROM artikel WHERE rubrikid=$rubrikid AND sichtbar='1' AND id >= $id ORDER BY id LIMIT 2";
$rs = @mysql_query( $abfrage,$con);
list($id, $name, $einleitung, $subhead0, $subhead1, $subhead2, $subhead3, $subhead4, $text0, $text1, $text2, $text3, $text4, $text5, $bildname, $bildanzahl, $bildtext0, $bildtext1, $bildtext2, $bildtext3, $bildtext4, $description, $keywords) = @mysql_fetch_row($rs);
list($id2, $name2, $einleitung2, $subhead02, $subhead12, $subhead22, $subhead32, $subhead42, $text02, $text12, $text22, $text32, $text42, $text52, $bildname2, $bildanzahl2, $bildtext02, $bildtext12, $bildtext22, $bildtext32, $bildtext42, $description2, $keywords2) = @mysql_fetch_row($rs);
$abfrage = "SELECT id, name FROM artikel WHERE rubrikid=$rubrikid AND id < $id ORDER BY id DESC LIMIT 2";
$rs = @mysql_query($abfrage);
list($id3, $name3) = @mysql_fetch_row($rs);
mysql_Close($con);
echo "";
echo "";
echo "
Haus & Markt Online - $name";
echo "";
echo "";
echo "";
echo "";
echo " ";
echo " ";
echo " | ";
echo " ";
echo " | ";
//---------------------------------------------------------Navigation oben
echo "";
//--------------------------------------------------------- Seitenkopf
echo "";
echo "";
//+++++++ diese abfrage ergänzen, archiv-bit richtig gesetzt?
//+++if($sichtbar = '2'){
//++ echo " Aus dem Haus & Markt Archiv: ";
//++}
//+++++++
echo " $name | ";
//echo "
| ";
echo " ";
echo "| ";
//------------------------------------------------------------- Text links
if ($einleitung != '') echo " $einleitung ";
if ($subhead0 != '') echo " $subhead0 ";
if ($text0 != '') echo " $text0 ";
if ($subhead1 != '') echo " $subhead1 ";
if ($text1 != '') echo " $text1 ";
if ($subhead2 != '') echo " $subhead2 ";
if ($text2 != '') echo " $text2 ";
if ($subhead3 != '') echo " $subhead3 ";
if ($text3 != '') echo " $text3 ";
if ($subhead4 != '') echo " $subhead4 ";
if ($text4 != '') echo " $text4 ";
echo" | ";
echo" | ";
echo"";
//--------------------------------------------------------- Tabelle mit Bildern rechts
echo"0){
echo " | | $bildtext0 | | | ";
}
if ($bildanzahl >1){
echo " | | $bildtext1 | | | ";
}
if ($bildanzahl >2){
echo " | | $bildtext2 | | | ";
}
echo " | ";
echo " | ";
echo "";
//--------------------google
echo "$amazon | ";
//------------------------------------------------------------- Seitenfuss
echo "
|