Re: Small update problem

Ok I got it working now. I changed the user to root and also removed the line that had $user= "test" Thank you so much list!! --- Ignacio Vazquez-Abrams <ignacio@openservices.net> wrote: > On Mon, 27 Nov 2000, Mike Mike wrote: > > > 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> > > > > > > > > > > Hmm. > > Does the user "web" have update permissions on > "UserName_Password"? > > -- > Ignacio Vazquez-Abrams <ignacio@openservices.net> > __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/