从不同的表插入时自动增量重叠

Question

I have two different tables. They are both different. The problem I'm having is;

the tables increments give me an error when I try to insert one row into the other table. For example:

I have one table where it stores the information of a pending registered user. So if someone register lets say they were given the id of 24. And in my other table i have around 56 members. How would I insert the pending member with the ID 24 into the members table without overlapping the ID's.

Edit:

Query's for adding it to pending registration:

 mysql_query("INSERT players SET user='$user', rank='$rank', date='$date', tag='$tag'", $db1)

or die(mysql_error());

Query for accepting the pending registration:

 if (isset($_GET['id']) && is_numeric($_GET['id']))
 {
 $id = $_GET['id'];

 $result=mysql_query("INSERT INTO players SELECT * FROM pending WHERE id=$id")
 or die(mysql_error()); 

 $result2= mysql_query("DELETE FROM pending WHERE id=$id")
 or die(mysql_error());  

Answer 1

Your problem is with:

"INSERT INTO players SELECT * FROM pending WHERE id=$id"

You probably do not want to insert the pending id into the players table. The id column in the players table should be auto increment and should not be set explicitly.

See https://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html on how to make a auto increment column.