Update database

Anon

Hi all,
Why won't this script update my database?

melb_edit_cat1.php

$query = "SELECT * FROM categories WHERE CatID = $id";

$result = mysql_query($query);
while($row = mysql_fetch_array($result)){

echo "Edit category details: ";
echo "<hr> ";
echo "<form method=post action=\"add_edit_cat1.php\">";
echo "Category: ";
echo "<input type=text name=address maxlength=100 size=25 value=\"{$row['CatName']}\"> ";
//echo "<input type=checkbox name=active value=yes> Check here to display this property on Melbourne Central ";

echo "<input type=submit value=\"SUBMIT\">";
echo "<input type=hidden name=bullet value=$id>";
echo "</form>";

Here is part of the script that is executed when the form is submitted.

add_edit_cat1.php

$query = "UPDATE categories SET CatName='$CatName' WHERE CatID=$bullet";

Everything appears to work but instead of updating the database with the new entry it leaves an empty value.
Any ideas on what the problem might be?

Cheers,
Rhett

fitzbean

$query = "UPDATE categories SET CatName='$CatName' WHERE CatID='$bullet'";

You didn't put single quotes on $bullet.

Anon

echo "<input type=text name=address maxlength=100 size=25 value=\"{$row['CatName']}\"> ";

name=address is wrong

it should be "name=CatName"