Small update problem

Hello Everyone, When I hit the submit button on a form the password feild doesn't change in the database. I don't recieve any error messages when I submit the form. What am I doing wrong? Heres the code. <? $user= "test" if ($submit) { // process form $db = mysql_connect("localhost", "web", "web"); mysql_select_db("UserName_Password",$db); $sql = "UPDATE user SET password='$password' WHERE user='$user'"; $result = mysql_query($sql); echo "Thank you! $user Your password is changed to $password.\n"; } else{ ?> <form method="post" action="<?php echo $PHP_SELF?>"> Password:<input type="Text" name="$password"><br> <input type="Submit" name="submit" value="Enter Password"> </form> <? } // end if ?> ========================================= The fields in the database are as follows +----------------------+ | ID | user | password | +----------------------+ Thanks for your help. --Mike __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/