$show_id AND group_id=$sub_id ORDER BY id ASC LIMIT 0,1"; } else if ($show_pos == -1){ $sql = "SELECT id,name,description,hint FROM jewelry WHERE id < $show_id AND group_id=$sub_id ORDER BY id DESC LIMIT 0,1"; }else { $sql = "SELECT id,name,description,hint FROM jewelry WHERE id=$show_id AND group_id=$sub_id"; } // Bild aus der Datenbanak abfragen, falls nicht gefunden, dann zurck zum Menu $result = mysql_query ($sql, $db); // Information laden list ($id,$name,$description,$hint) = mysql_fetch_array ($result); mysql_free_result($result); // Falls kein Bild in der Datenbank gefunden, dann zum Anfang if (!$id || !$result) header ("Location: ringe.phtml?sub_id=$sub_id"); /*---------------------------------------------------------------- Kopf zeichnen ---------------------------------------------------------------*/ // Inhalt aus der Datenbank holen $result = mysql_query ("SELECT html_title, html_description, html_keywords, page_title, page_content FROM content WHERE jewelry_group_id='$sub_id'"); list ($html_title, $html_description, $html_keywords, $page_title, $page_text) = mysql_fetch_array ($result); mysql_free_result($result); print_head($url_path, "trauringe", $html_title, $html_description, $html_keywords); // Zeichne Titel und Inhalt draw_page_title ($functions->conv_input($name)); // Zeichne das Schmuckstckbild echo "
\n"; draw_main_text ($functions->conv_input($description)); // Navigationsleiste zeichnen draw_navig_pictures ("$PHP_SELF?show_pos=-1&show_id=$id&sub_id=$sub_id", "Vorhergehendes Stück anzeigen", "$url_path/ringe/ringe.phtml?sub_id=$sub_id", "Zurück zu unserer Galerie", "$PHP_SELF?show_pos=1&show_id=$id&sub_id=$sub_id", "Nächstes Stück anzeigen", $url_path); /*---------------------------------------------------------------- Fu�zeichnen ---------------------------------------------------------------*/ print_foot($url_path); ?>