Medtag kategori
Hej, jeg har et stykke kode, der skal smide nogen oplysninger ind i en database, men problemet er bare at den ikke medtager kategori variablen! Koden ser sådan her ud:<?
if (!$mode) {
echo"
<table border=\"0\" cellpadding=\"2\" cellspacing=\"0\" width=\"100%\">
<tr>
<td valign=\"top\">
<p align=\"center\"> </p>
<form action=\"nylink2.php?mode=tilfoj&kat=$kategori\" method=\"post\"><br><br>
<div align=\"center\">
<center>
<table border=\"0\" cellpadding=\"3\" cellspacing=\"0\">
<tr>
<td width=\"133\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Titel
:</font></td>
<td width=\"425\"> <font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">
<INPUT TYPE=\"text\" name=\"titel\" class=\"tekstboks\" size=\"36\">
</font></td>
</tr>
<tr>
<td height=\"2\" width=\"133\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Filnavn
(uden fil adresse):</font></td>
<td height=\"2\" width=\"425\"> <font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">
<input type=\"text\" name=\"fil\" size=\"36\">
</font></td>
</tr>
<tr>
<td width=\"133\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">Kategori:</font></td>
<td width=\"425\">
<select name=\"id\" size=\"1\" style=\"width=250\">
<option value=\"0\">Vælge kategori</option>";
include ("connect.php");
$result = mysql_query("SELECT * FROM kategori order by id");
while ($row = mysql_fetch_array($result)) {
$kategori = $row["kategori"];
$id2 = $row["id"];
if ($id2==$kategori){
echo "<OPTION value=\"$id2\" selected>$kategori</OPTION>";
}
else {
echo "<OPTION value=\"$id2\">$kategori</OPTION>";
}
}
echo"
</td>
</tr>
<tr>
<td width=\"133\"><font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\"></font></td>
<td width=\"425\"> <font face=\"Verdana, Arial, Helvetica, sans-serif\" size=\"1\">
<input type=\"submit\" value=\" Tilføj \" class=\"knap\">
</font></td>
</tr>
</table>
</center>
</div>
</form>
</td>
</tr>
</table>
";
}
if ($mode == "tilfoj") {
include ("connect.php");
// Smider informationerne ind i MySQLen
$titel = nl2br($titel);
$fil = nl2br($fil);
$query = mysql_query("INSERT INTO menu (titel, fil, kategori)" . "VALUES ('$titel','$fil', '$kat')");
print "
<center>
<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">
<tr>
<td>
<p align=\"center\">Links tilføjet !</p>
</center>
<td>
</tr>
</table>
";
}
?>
Er der en der kan se fejlen?
