Board Game Arena

Thanks you all. I'd tried using two statements separated with a ';', but it wouldn't work. I'll try it again since my SQL-foo is very weak and I might have missed something. I haven't tried the IF-CASE thing, so I'll give that a try too. I'll post back here if I get something working. I think Ricard...

In my game, I need to move a pawn from one square on the board to another. So far, the only way I've gotten this to work, is via two separate database updates: UPDATE board SET board_player=NULL WHERE ( board_row = 6 AND board_col = 1 ) UPDATE board SET board_player='2321571' WHERE ( board_row = 6 A...