Salve salvino!

Sto cercando di creare un sistema per la gestione delle categorie in un sito... solo che ovviamente non funziona mi aiutate a trovare l'errore?

Allora, le tabelle nel db sono:

category:
id (primary key)
name

photocategory:
categoryid (primary key)
imgid (primary key)

poi ho: cats.php:

codice:
<h1>Gestione Categorie</h1>
<ul>
<?php
include('include/database.php');
$cats = @mysql_query('SELECT id, name FROM category');
if (!$cats){
    exit ('

Error retrieving categories from database!
'. 'Error: ' . mysql_error(). '</p>');
}
while ($cat = mysql_fetch_array($cats)) {
    $id = $cat['id'];
 $name = htmlspecialchars($cat['name']);
 echo "[*]$name ".
      "Edit| ".
   "Delete";
}
?>[/list]


Add a new category</p>


Return to home page</p>
newcat.php:

codice:
<title>Aggiungi Categoria</title>
</head>
<body>
<?php
if (isset($_POST['name'])):
include("include/database.php");
$name = $_POST['name'];
$sql = "INSERT INTO category SET name='$name'";
if (@mysql_query($sql)) {
   echo '

New category added</p>';
   } else {
   echo '

Error adding new category: ' .
   mysql_error() . '</p>';
}
?>


Add another category</p>


Return to categoty</p>
<?php else: ?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">


Enter the new category:</p>
<label>Name: <input type="text" name="name" /></label>

<input type="submit" value="SUBMIT" />
</form>
<?php endif; ?>
editcat.php

codice:
<title>Modifica categorie</title>
</head>
<body>
<?php
include('include/database.php');
 
if (isset($_POST['name'])):
   $name = $_POST['name'];
   $id = $_POST['id'];
   $sql = "UPDATE category SET name='$name' WHERE id='id'";
   if (@mysql_query($sql)) {
   echo '

Category details updated.</p>';
   } else {
   echo '

Edrror updating category details: ' .
   mysql_error() . '</p>';
   }
?>


Return to category list</p>
<?php else:
$id = $_GET['id'];
$cat = @mysql_query("SELECT name FROM category WHERE id='$id'");
if (!$cat) {
exit('

Error fetching category details: ' . mysql_error() . '</p>');
}
$cat = mysql_fetch_array($cat);
$name = $cat['name'];
$name = htmlspecialchars($name);
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">


Modifica la categoria:</p>
<label>Nuovo nome: <input type="text" name="name" value="<?php echo $name; ?>" /></label>

<input type="hidden" name="id" value="<?php echo $id; ?>" />
<input type="submit" value="SUBMIT" /></p>
</form>
<?php endif; ?>
e infine deletecat.php:

codice:
<title>Cancella categorie</title>
</head>
<body>
<?php
include('include/database.php');
$id = $_GET['id'];
$ok1 = @mysql_query("DELETE FROM photocategory WHERE categoryid='$id'");
$ok2 = @mysql_query("DELETE FROM category WHERE id='$id'");
if ($ok1 and $ok2) {
   echo 'Category deleted successfully!';
   }
else {
   echo '

Error deleting category from database! 
';
   'Error: ' . mysql_error() . '</p>';
}
?>


Return to category list</p>
Innanzi tutto come errore mi dice

Notice: Undefined index: id

sia in deletecat.php che in editcat.php

e poi cmq nn fa quello che dovrebbe fare! Cioè, aggiunge e basta, ma non edita e non cancella!



HELP!