mysql_query("update.. vil ikke opdatere
Godaften... Ja - har det her script som gerne vil oprette i databasen, men ikke opdatere... Scriptet er som følger:<?php
//Når der er trykket på en knap sker det her
$name = $_POST['name'];
$url = $_POST['url'];
if ($_POST['submit'] == "Opret!")
{
mysql_query("INSERT INTO menu (name,url) VALUES ('$name','$url')",$db);
echo "Oprettet!";
}
if ($_POST['submit'] == "Slet!")
{
mysql_query("DELETE FROM menu WHERE name='$name'",$db);
echo "Slettet!";
}
if ($_POST['submit'] == "Opdater!")
{
mysql_query("UPDATE menu SET name='$_POST[name]','url=$_POST[url]' WHERE id=$_POST[id]",$db);
echo "Opdateret!";
}
//Her er formen så
$mode = $_GET['mode'];
$query = mysql_query("SELECT * FROM menu ORDER BY id",$db);
$query2 = mysql_query("SELECT * FROM menu ORDER BY id",$db);
$menu = mysql_fetch_assoc($query2);
echo "<form action=\"".$PHP_SELF."\" method=\"post\">";
echo "<table width=\"575\" class=\"mainindhold\">";
echo "<tr>";
echo "<td colspan=\"4\"><h1>Rediger menupunkter</h1></td>";
echo "</tr>";
if ($mode == "new")
{
echo "<input type=\"hidden\" name=\"id\" value=\"".$menu['id']."\">";
echo "<tr>";
echo "<td width=\"175\" class=\"boksheading\">Linknavn:</td><td class=\"boksheading\" colspan=\"4\">URL:</td></tr><tr>";
echo "<td width=\"175\"><input type=\"tekst\" class=\"tekstboks\" name=\"name\" value=\"\"><br><br></td><td><input type=\"tekst\" class=\"tekstboks\" name=\"url\" value=\"\"><br><br></td><td width=\"50\"><input type=\"submit\" class=\"knap\" name=\"submit\" value=\"Opret!\"><br><br></td><td width=\"50\"><br><br></td>";
echo "</tr>";
} else {
while($menu = mysql_fetch_assoc($query))
{
echo "<input type=\"hidden\" name=\"id\" value=\"".$menu['id']."\">";
echo "<tr>";
echo "<td width=\"175\" class=\"boksheading\">Linknavn:</td><td class=\"boksheading\" colspan=\"4\">URL:</td></tr><tr>";
echo "<td width=\"175\"><input type=\"tekst\" class=\"tekstboks\" name=\"name\" value=\"".$menu['name']."\"><br><br></td><td><input type=\"tekst\" name=\"url\" class=\"tekstboks\" value=\"".$menu['url']."\"><br><br></td><td width=\"50\"><input type=\"submit\" class=\"knap\" name=\"submit\" value=\"Opdater!\"><br><br></td><td width=\"50\"><input type=\"submit\" class=\"knap\" name=\"submit\" value=\"Slet!\"><br><br></td>";
echo "</tr>";
}
}
echo "</table>";
echo "</form>";
?>
Pue ha det var en lang smøre.. Hvad skyldes at den ikke vil opdatere?
