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
