Just to let everybody know. I found my stupid problem. I was executing the statement twice.
Thanks Steve At 03:58 PM 3/27/2002, you wrote: >I hope that someone can help me with this. I understood that if I do an >update on a row in a table, I could use the SET row=row+1 and that would >take what was in that row/column and add a 1 to it. For some reason, it >is doubling it. My end result is always twice what it should be. Can >anybody explain what I am doing wrong? >I have a MySQL Update statement like the following. The variables will >either be a 1 (one) or a 0 (zero). >---------- >"UPDATE $d >SET w = w+$win, >l = l+$loss, >t = t+$tie, >pts = pts+$pts, >max_pt = max_pt+$max_pt >where team_id = '$team_id' and sea_id = '$sea_id'"; >---------- > >I even put the following line in right before the UPDATE to make sure that >it was putting it in only once so that I could get a printout (I am using PHP): >echo "team $team_id - win $win, loss $loss, tie $tie<br>"; >Why would my results in the database be double what they should be. I >even changed the first set from: >w = w+$win >to >w = w+1 >and sure enough, instead of the expected result of 7, I got 14. > >Thank You in Advance >Steve > > > >--------------------------------------------------------------------- >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
