Re: Small update problem

On Mon, 27 Nov 2000, Mike Mike wrote: > 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/ > Try: mysql_query($sql, $db); -- Ignacio Vazquez-Abrams <ignacio@openservices.net>