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
