Nope, privs are the same. Tyler
----- Original Message ----- From: "Daniel Rosher" <[EMAIL PROTECTED]> To: "Tyler Longren" <[EMAIL PROTECTED]> Cc: "MySQL List" <[EMAIL PROTECTED]>; "DL Neil" <[EMAIL PROTECTED]> Sent: Tuesday, February 26, 2002 5:19 PM Subject: RE: "SET field=field+1" no longer works? > 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