update record

update record

by muratsal » Tue Nov 20, 2012 9:41 am

i wanto update record but firstly i should control what the state . So first select and update but maybe other user change the value of record.
How to guarentee that my update is valid .
example if colum value is null set your id but when you send select query other user can set value and ı set over it .

Re: update record

by XainPro » Wed Nov 21, 2012 4:35 am

please explain further with your query and code i do not understand what you are talking about.

Re: update record

by muratsal » Wed Nov 21, 2012 9:34 am

code about joinin online game
1 game creator and 1 rival
when user create game
gameid,gamename,...,rivalId,state,.. there is table like this.

i control if rivalId is null createor vait for rival if anyuserId game start
but problem is when a user wanto join a game, user control if rivalId null if it is null user set itself id .
problem when select this record maybe any ather uset set him/her userid,

understand ? sorry for bad english :)

Re: update record

by XainPro » Sat Nov 24, 2012 7:22 am

sorry did not understand :(
show your code what you really want ?
is your problem related with code or database ?