Hi Tyler,
Apologies for the absence/delay. Pleased to hear that the problem is solved.
It does raise the question though - if it failed in PHP (etc) how did you manage to
get it to work in
MySQL-client?
If an UPDATE flat refuses to go (which didn't seem to be the case here), then the
first 'check' should be to
substitute/paste the WHERE clause into a SELECT query. As it turns out, that would
have highlighted the problem
for you!
Regards,
=dn
> This was my bad. I forgot that I had encoded all passwords with
> base64_encrypt() in PHP. So, the passwords in the database weren't in their
> plaintext forms. So, my password wasn't matching up with what was in the
> database.
>
> Everything works good now. :)
>
> Thanks for your help!
> tyler
>
> ----- Original Message -----
> From: "Stewart Gateley" <[EMAIL PROTECTED]>
> To: "Tyler Longren" <[EMAIL PROTECTED]>; "DL Neil"
> <[EMAIL PROTECTED]>
> Cc: "MySQL List" <[EMAIL PROTECTED]>
> Sent: Tuesday, February 26, 2002 5:56 PM
> Subject: Re: "SET field=field+1" no longer works?
>
>
> > Try:
> >
> > UPDATE users SET board_posts=(board_posts+1) WHERE username='tyler' AND
> > password='myfakepassword';
> >
> >
> > I am using <? mysql_query ("update $table set hits=(hits+1) where
> > id=$id"); ?> and it works fine.
> >
> > -- Stewart
> >
> > --- Tyler Longren <[EMAIL PROTECTED]> wrote:
> > > Well, here's the query that PHP is generating:
> > > UPDATE users SET board_posts=board_posts+1 WHERE username='tyler' AND
> > > password='myfakepassword'
> > >
> > > If I copy and paste that exactly into the mysql client, it's executed
> > > correctly. If I use phpMyAdmin to execute it, it IS NOT executed
> > > correctly
> > > (same as in my PHP code). I really don't think this is a problem
> > > with my
> > > coding since it worked with previous versions of mysql. Could PHP
> > > just be
> > > screwing up while sending the query to MySQL?
> > >
> > > Also, if I use MySQL Front (www.mysqlfront.de), the query doesn't get
> > > executed properly. It only works correctly when issuing the query
> > > from the
> > > mysql command line client. :)
> > >
> > > Tyler
> > >
> > > ----- Original Message -----
> > > From: "DL Neil" <[EMAIL PROTECTED]>
> > > To: "Tyler Longren" <[EMAIL PROTECTED]>
> > > Cc: <[EMAIL PROTECTED]>
> > > Sent: Tuesday, February 26, 2002 8:52 AM
> > > Subject: Re: "SET field=field+1" no longer works?
> > >
> > >
> > > > Hi Tyler,
> > > > [back on-list so that others can offer their wisdom!]
> > > >
> > > > OK, so it's not a problem with the MySQL client, then it's likely
> > > the PHP.
> > > Most likely that the username and
> > > > password data values are strings and need to be properly contained
> > > with
> > > single- or double-quotation marks.
> > > >
> > > > If you need further assistance, first try some debug ECHOs on the
> > > three
> > > fields used in the query, and ECHO the
> > > > query itself immediately prior to the call to MySQL. (is the last
> > > how you
> > > posted (copy-pasted) the query into
> > > > the MySQL client, or did you type it into MySQL by hand?)
> > > >
> > > > If lights still don't go off, please post the PHP code snippet.
> > > >
> > > > Regards,
> > > > =dn
> > > >
> > > >
> > > > > I tried it in PHP first, and it doesn't work in that. But, when
> > > I use
> > > the
> > > > > mysql client, it works as expected. Any ideas?
> > > >
> > > >
> > > > > > Hello Tyler,
> > > > > >
> > > > > > Did someone pick up this question - haven't spotted a response
> > > on the
> > > > > list?
> > > > > > I haven't spotted any such mis-behavior under either Win2000 or
> > > WinNT.
> > > > > >
> > > > > > Are you entering the query at the command line or into some
> > > tool?
> > > > > > Have you tried another client?
> > > > > >
> > > > > > If it is still unresolved, send me (NOT the whole list) the
> > > actual
> > > query,
> > > > > and a short table with sample data,
> > > > > > and I'll try it on my two Win boxes here.
> > > > > >
> > > > > > Regards,
> > > > > > =dn
> > > > > >
> > > > > >
> > > > > > > I'm running MySQL on a Windows 2000 box. I was running
> > > 3.23.47
> > > until
> > > > > > > 3.23.49 was released. After upgrading to 3.23.49, queries
> > > like this
> > > > > don't
> > > > > > > work:
> > > > > > > UPDATE test_table SET board_posts=board_posts+1 WHERE
> > > username='blah'
> > > > > AND
> > > > > > > password='blah';
> > > > > > >
> > > > > > > Normally, that would increment the value in board_posts by 1,
> > > this
> > > no
> > > > > longer
> > > > > > > happens. Is there a different way I should do this now?
> > > > > > >
> > > > > > > Thanks,
> > > > > > > Tyler
> > > > > > >
> > > > > > >
> > > > > >
> > > >
> > > ---------------------------------------------------------------------
> > > > > > > Before posting, please check:
> > > > > > > http://www.mysql.com/manual.php (the manual)
> > > > > > > http://lists.mysql.com/ (the list archive)
> > > > > > >
> > > > > > > To request this thread, e-mail
> > > <[EMAIL PROTECTED]>
> > > > > > > To unsubscribe, e-mail
> > > > > <[EMAIL PROTECTED]>
> > > > > > > Trouble unsubscribing? Try:
> > > http://lists.mysql.com/php/unsubscribe.php
> > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > ---------------------------------------------------------------------
> > > > > > Before posting, please check:
> > > > > > http://www.mysql.com/manual.php (the manual)
> > > > > > http://lists.mysql.com/ (the list archive)
> > > > > >
> > > > > > To request this thread, e-mail
> > > <[EMAIL PROTECTED]>
> > > > > > To unsubscribe, e-mail
> > > > > <[EMAIL PROTECTED]>
> > > > > > Trouble unsubscribing? Try:
> > > http://lists.mysql.com/php/unsubscribe.php
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > ---------------------------------------------------------------------
> > > > Before posting, please check:
> > > > http://www.mysql.com/manual.php (the manual)
> > > > http://lists.mysql.com/ (the list archive)
> > > >
> > > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > > Trouble unsubscribing? Try:
> > > http://lists.mysql.com/php/unsubscribe.php
> > > >
> > > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > Before posting, please check:
> > > http://www.mysql.com/manual.php (the manual)
> > > http://lists.mysql.com/ (the list archive)
> > >
> > > To request this thread, e-mail <[EMAIL PROTECTED]>
> > > To unsubscribe, e-mail
> > > <[EMAIL PROTECTED]>
> > > Trouble unsubscribing? Try:
> > > http://lists.mysql.com/php/unsubscribe.php
> > >
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Greetings - Send FREE e-cards for every occasion!
> > http://greetings.yahoo.com
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
