Have privileges changed? Dan
> -----Original Message----- > From: Tyler Longren [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 27 February 2002 11:55 a.m. > To: DL Neil > Cc: MySQL List > Subject: Re: "SET field=field+1" no longer works? > > > 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 --------------------------------------------------------------------- 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