\n"; echo "

Grafik-Datenbank "Wahlbarometer '03"

"; // echo "

Zugangsberechtigung passwortgeschützt

"; // echo "

Mit dieser Datenbank können Sie folgendes tun:
"; // echo "

Auswertungen eine Frage über mehrere Wellen
"; // echo "Auswertungen zwei Fragen innerhalb einer Welle
"; // echo "Auswertungen zwei Fragen über alle Wellen
"; // echo "gefilterte Auswertungen zwei Fragen über alle Wellen
"; // echo "

\n"; // echo "Handbuch
\n"; // echo "
\n"; echo "

Zur Einsicht in den Fragetext klicken Sie auf den "; echo "Fragetitel in der ersten Spalte.
"; echo "Um eine Grafik anzusehen, klicken Sie in einer Wellenspalte auf den Dateinamen.
"; echo "Leere Zellen in einer Wellenspalte symbolisieren, dass keine Grafik verfügbar ist.
\n"; echo "Grafiken in der Spalte "Trend" stellen Vergleiche unter den Wahlbarometer-Wellen dar.

"; // echo "über alle Wellen.

\n"; // echo "

\n"; $db = @MYSQL_CONNECT($db_server,$db_user,$db_passwort) or die ("Konnte keine Verbindung zur Datenbank herstellen"); $db_select = @MYSQL_SELECT_DB($db_name) or die ("Konnte keine Verbindung zur Datenbank herstellen"); $sql = "SELECT * FROM Fragen ORDER BY Nr"; $resultat = mysql_query($sql); $durch=0; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; // echo "\n"; // echo "\n"; // echo "\n"; echo "\n"; WHILE ($row=mysql_fetch_row($resultat)){ $durch=$durch+1; echo "\n\n"; $sql = "SELECT Pool, Karte, Trend, Welle01, Welle02, Welle03, Welle04, Welle05, Welle06, Welle07 FROM Fragen WHERE Nr='$durch'"; $result = mysql_query($sql); $myrow = mysql_fetch_array($result); $Pool = $myrow["Pool"]; $Karte = $myrow["Karte"]; $Trend = $myrow["Trend"]; $Welle01 = $myrow["Welle01"]; $Welle02 = $myrow["Welle02"]; $Welle03 = $myrow["Welle03"]; $Welle04 = $myrow["Welle04"]; $Welle05 = $myrow["Welle05"]; $Welle06 = $myrow["Welle06"]; $Welle07 = $myrow["Welle07"]; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; // echo "\n"; // echo "\n"; // echo "\n"; echo "\n"; } echo "

"; echo "Variable\n"; echo "

"; echo "Welle 7
September 2003
"; echo "

"; echo "Welle 6
August 2003
"; echo "

"; echo "Welle 5
Juni 2003
"; echo "

"; echo "Welle 4
April 2003
"; echo "

"; echo "Welle 3
März 2003
"; echo "

"; echo "Welle 2
Jan 2003
"; echo "

"; echo "Welle 1
Okt 2002
"; echo "

"; echo " Trend "; echo "

"; echo " Pool "; echo "

"; echo " Karte "; echo "

"; // echo "Welle 3
Mär 2002"; // echo "

"; // echo "Welle 4
Okt 2002"; // echo "

"; // echo "Welle 5
... 2003"; // echo "

"; $sql = "SELECT Label FROM Fragen WHERE Nr='$durch'"; $result = mysql_query($sql); $myrow = mysql_fetch_array($result); $Label = $myrow["Label"]; $sql = "SELECT Variabel FROM Fragen WHERE Nr='$durch'"; $result = mysql_query($sql); $myrow = mysql_fetch_array($result); $Variabel = $myrow["Variabel"]; echo "$Label"; echo " "; echo "

"; if ($Welle07 !="") { echo " $Welle07 "; } else { echo " "; } echo "

"; if ($Welle06 !="") { echo " $Welle06 "; } else { echo " "; } echo "

"; if ($Welle05 !="") { echo " $Welle05 "; } else { echo " "; } echo "

"; if ($Welle04 !="") { echo " $Welle04 "; } else { echo " "; } echo "

"; if ($Welle03 !="") { echo " $Welle03 "; } else { echo " "; } echo "

"; if ($Welle02 !="") { echo " $Welle02 "; } else { echo " "; } echo "

"; if ($Welle01 !="") { echo " $Welle01 "; } else { echo " "; } echo "

"; if ($Trend !="") { echo " $Trend"; } else { echo " \n"; } echo "

"; if ($Pool !="") { echo " $Pool"; } else { echo " \n"; } echo "

"; if ($Karte !="") { echo " $Karte"; } else { echo " "; } echo "

"; // if ($Welle03 !="") { // echo " $Welle03 "; // } // else // { // echo " "; // } // echo "

"; // if ($Welle04 !="") { // echo " $Welle04 "; // } // else // { // echo " "; // } // echo "

"; // if ($Welle05 !="") { // echo " $Welle05 "; // } // else // { // echo " "; // } // echo "

\n"; echo "\n"; echo ""; ?>