problems with matching id in two different tables

[victor78]

I have two tables where the two id's are exactly the same. Both ids are auto incremented.

There are table users and table players.

table users contains:

id
username
password
player_id
and some more stuff irrevelent to the problem.

table players contains

player_id
player_name
and some more stuff irrevelent to the problem

What I am trying to do is insert into both tables so that the player_ids match. later on, I will be updating them by the player_ids.

Here are my statements. Note that $obj is just an sql class.

$sql = "INSERT INTO players VALUES ('', '$name[$z]', '0', 'N/A', 'N/A', 'Unknown', '$dkp_earnt[$z]', '0','0','0')";

$result = $obj->Query($sql);
$sql1 = "INSERT INTO users VALUES('', 'unregistered', 'none', 'N/A', 'N/A', LAST_INSERT_ID(), '$time', '0.0.0.0','0')";
$result1 = $obj->Query($sql1);

I know this is vague, but when these statement occurs I notice a large gap in the inserts. What I mean is this: Say I will have 1 to 50 ids, then the next insert I will have 75 to 100. I believe I have a bug in my script and it is inserting null items. Is this possible? What can php cause large gaps like that.

[jkeppens]

Did you delete records at the end?

[victor78]

No I didn't, but when the player information is entered into the database. It has to be sorted first for calculations.

Here is the code trimmed down to only show the most important things. This code is reading from a log file which has names and times. It calculates the difference between times, and then computes a score for each of them. If the players dont exist, it will enter them in, if they do exist, it will update there scores.

I attached my code as a file, as it is a little long.

Here is one liine from the log.

[Sat Mar 02 20:34:36 2002] [53 Vicar] Llayce (Dark Elf) <Shining Path>

If you recognize this line, get help immediately. 😉

[victor78]

I managed to work it out, but still can't figure out why the id's are not going in order, no biggie though.