} else { $sql = "SELECT id FROM qz_kategori ORDER BY RAND();"; } $result = connectDB()->query($sql); /*if (@!$_GET['svar'] == 1) { echo '<a href="?svar=1">Fasit</a>'; } else { echo '<a href="">Tilbake</a>'; }*/ if ($result->num_rows > 0) { echo '<form action="" method="POST">'; // output data of each row while ($row = $result->fetch_assoc()) { $kategoriID = $row["id"]; echo "<h3>" . HentKategorinavnFraKategoriID($kategoriID) . "</h3>"; $sql2 = "SELECT * FROM qz_sporsmaal WHERE kategoriID = '{$kategoriID}' ORDER BY RAND() LIMIT " . $totalt_antall_sporsmaal_per_kategori . ";"; $result2 = connectDB()->query($sql2); if ($result2->num_rows > 0) { // output data of each row while ($row2 = $result2->fetch_assoc()) { $sporsmaalID = $row2["id"]; echo "<br><h4><strong>" . HentSporsmaalFraSporsmaalID($sporsmaalID) . "</strong></h4>"; echo '<input type="hidden" name="sporsmaalID[]" value="' . $sporsmaalID . '">'; // Spørsmål ID $sql3 = "SELECT * FROM qz_svar WHERE sporsmaalID = '{$sporsmaalID}' ORDER BY RAND();"; $result3 = connectDB()->query($sql3); if ($result3->num_rows > 0) { // output data of each row while ($row3 = $result3->fetch_assoc()) { $svarID = $row3["id"];
<h2>Legg til svaralternativ:</h2> <form action="" method="POST"> Spørsmål: <select name="spørsmålID" required> <?php connectDB(); $sql = "SELECT * FROM qz_sporsmaal GROUP BY kategoriID;"; $result = connectDB()->query($sql); if ($result->num_rows > 0) { echo '<option selected disabled>Velg spørsmål</option>'; // output data of each row while ($row = $result->fetch_assoc()) { $kategoriID = $row["kategoriID"]; $sql2 = "SELECT * FROM qz_sporsmaal WHERE kategoriID = '{$kategoriID}';"; $result2 = connectDB()->query($sql2); echo '<optgroup label="' . HentKategorinavnFraKategoriID($kategoriID) . '">'; if ($result2->num_rows > 0) { while ($row2 = $result2->fetch_assoc()) { $id2 = utf8_encode($row2["id"]); $sporsmaal2 = utf8_encode($row2["sporsmaal"]); echo "<option value=" . $id2 . ">" . $sporsmaal2 . "</option>"; } } echo '</optgroup>'; } } else { echo "<option selected disabled>Ingen spørsmål</option>"; } connectDB()->close(); ?> </select>