Hvorfor virker submit knap ik ?
<?phprequire "db.php";
$pr_side = 6;
$antal = mysql_result(mysql_query("SELECT COUNT(*) FROM bixen_vrag_msg WHERE replyto='$id'"),0) or die(mysql_error());
$vis_fra = (isset($_GET["visfra"]) && is_numeric($_GET["visfra"]) && $_GET["visfra"] < $antal) ? $_GET["visfra"] : 0;
$res = mysql_query ("SELECT * FROM bixen_vrag_msg WHERE replyto='$id' ORDER BY id DESC limit $vis_fra, $pr_side") or die(mysql_error());
if(isset($_POST['submit'])) {
require 'db.php';
$sql1 = mysql_query("SELECT replyto FROM bixen_vrag_msg");
if($row=mysql_fetch_array($sql1)) {
$godkendt = $_GET['godkendt'];
$id = $_GET['id'];
$replyto = $row['replyto'];
}
echo "id: $id";
echo "replyto: $replyto";
mysql_query("UPDATE bixen_vrag_msg SET godkendt='$godkendt' WHERE replyto ='$id'") or die(mysql_error());
echo "<div align=\"center\" class=\"tekst_linkThin\">Kommentar opdagteret</div>";
}
if (mysql_num_rows($res)== '0') {
print "<center>Der er ingen kommentare skrevet!<br><br><input type=button value=\"Tilbage\" class=\"input\" onClick=\"java script: history.go(-1)\"></center>";
} else {
echo"<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">
<tr bgcolor=\"5175A5\">
<td width=\"31%\"><span class=\"bil\">Model:</span></td>
<td width=\"19%\"><span class=\"bil\">Navn:</span></td>
<td width=\"36%\"><span class=\"bil\">Kommentar:</span></td>
<td width=\"14%\"><span class=\"bil\">Godkendt:</span></td>
</tr>";
while($row = mysql_fetch_array($res)) {
$replyto = $row['replyto'];
echo "<tr>
<td>";
$sql = "SELECT model FROM bixen_vrag WHERE id ='$replyto'";
$model = mysql_query($sql);
if (mysql_num_rows($model) < '0') {
echo " "; } else {
echo mysql_result($model, '$row[model]' );
}
echo"</td>
<td>";
if (empty($row['navn'])) { echo " "; } else {
echo $row['navn'];
}
echo "</td>
<td>";
if (empty($row['besked'])) { echo " "; } else {
$besked = explode(" ", $row["besked"]);
$besked = array_slice($besked, 0, 30);
$besked = implode(" ", $besked);
echo $besked;
}
echo "</td>
<td valign=\"top\">";
if (empty($row['godkendt'])) { echo " "; } else {
echo "<form action=\"valgtvrag.php?id=$id\" name=\"godkendt\" method=\"POST\">";
$sql2 = mysql_query("SELECT godkendt FROM bixen_vrag_msg");
$godkendt = $row['godkendt'];
if($row=mysql_fetch_array($sql2)) {
echo "<select size=\"1\" name=\"godkendt\">";
if ($godkendt =="NEJ") print('<option value="NEJ" selected>Nej</option>');
else print('<option value="NEJ">Nej</option>');
if ($godkendt =="JA") print('<option value="JA" selected>Ja</option>');
else print('<option value="JA">Ja</option>');
}
echo "</select>";
echo "<input type=\"submit\" name=\"submit\" value=\"Opdagter\"></form>";
}
echo"</td>
</tr>";
echo "<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>";
}
echo "</table>";
?>
Dette er min kode, men jeg kan ik få den til at ligge det ordentligt op i min DB.. Får vist fint fat i min DB, men skriver intet i feltet "godkendt" det bliver bare et helt tomt felt..
