RE: [PHP] Small update problem

Get rid of the $ sign in the field name... Make it <input type="Text" name="password"> __________________________________ Lorenzo Curtis Website/Database Developer prexar - internet and beyond lorenzo.curtis@prexar.com (207) 974-4334 -----Original Message----- From: Ignacio Vazquez-Abrams [mailto:ignacio@openservices.net] Sent: Monday, November 27, 2000 3:32 PM To: Mike Mike Cc: php-general@lists.php.net Subject: Re: [PHP] 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> -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net