$result = db_access($MySQL_DB,"LOCK TABLES Numbers WRITE"); $result = db_access($MySQL_DB,"SELECT Number FROM Numbers WHERE Name = '$Name'"); $row = mysql_fetch_array($result); $NewNumber = $row[0] + 1; $result = db_access($MySQL_DB,"REPLACE INTO Numbers SET Name = '$Name', Number = $NewNumber"); $result = db_access($MySQL_DB,"UNLOCK TABLES");