Re: Small update problem

Still a no go. I put a couple of echos in to see what I'm getting for values. echo "Thank you! $login Your password is changed to $password.\n"; OUT PUT... UserName test Password: testThank you! test Your password is changed to test. Any more ideas? --- Ignacio Vazquez-Abrams <ignacio@openservices.net> wrote: > 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> > > __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/