Re: Small update problem
| From: | Ignacio Vazquez-Abrams | Date: | Mon, 27 Nov 2000 20:55:48 +0000 |
| Subject: | Re: Small update problem | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-27460@lists.php.net to get a copy of this message | ||
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>