Search the Community

I have the following piece of code (if anyone can think of a better way then please tell me). mysql_query("BEGIN"); #NOTE that we are only going to load in games that need to be updated so there is no need to set an IF statement if(@$my_team['inGame']) {$my_team_ID = $my_team['inGame'];} else{$my_team_ID=0;} $matches = mysql_query("SELECT * FROM matches WHERE completed=0 and $current_time > updateTime ORDER BY matchID ASC LOCK IN SHARE MODE "); //Get all the matches that need updating while($match = mysql_fetch_array($matches)) { //Go through all the matches that need updating $notes .= "<p>MatchID - ".$match['matchID']." ".$match['homeTeam']." V ".$match['awayTeam']; $updateTime=$match['updateTime']; #Get the updateTime from the match ID include("run_game.php"); #This is the actual file that runs the game $notes .= "<BR>This is the string data".$stringData."<BR>"; #Output it to make sure it works } mysql_query("COMMIT"); # Here the datarecords are released and the transaction is completed This code works fine - the 'matches' database is only updated once; the problem is if it is run from two differant directions then ANOTHER part of the code in run_game.php is run and updated, this is not what I wanted How can I get this query NOT to activate on locked rows? I tried Google but I dont' know what to search for