database update script

1 files changed, 11 insertions, 14 deletions

diff --git a/includes/pages/guest_faq.php b/includes/pages/guest_faq.php
index e639731b..9d65bb36 100644
--- a/includes/pages/guest_faq.php
+++ b/includes/pages/guest_faq.php
@@ -1,22 +1,19 @@
 <?php
 function guest_faq() {
 	$html = "";
-	$faqs = sql_select("SELECT * FROM `FAQ`");
+	if ($_SESSION['Sprache'] == "DE") {
+		$faqs = sql_select("SELECT * FROM `FAQ` WHERE `Sprache` = 'de'");
+	} else {
+		$faqs = sql_select("SELECT * FROM `FAQ` WHERE `Sprache` = 'en'");
+	}
+
 	foreach ($faqs as $faq) {
 		$html .= "<dl>";
-		if ($_SESSION['Sprache'] == "DE") {
-			$html .= sprintf(
-				'<dt>%s</dt> <dd>%s</dd>',
-				$faq['Frage_de'],
-				$faq['Antwort_de']
-			);
-		} else {
-			$html .= sprintf(
-				'<dt>%s</dt> <dd>%s</dd>',
-				$faq['Frage_en'],
-				$faq['Antwort_en']
-			);
-		}
+		$html .= sprintf(
+			'<dt>%s</dt> <dd>%s</dd>',
+			$faq['Frage'],
+			$faq['Antwort']
+		);
 		$html .= "</dl>";
 	}
 	return $html;