RE: [PHP] Inserting records in a particular way in MySQL

2003-02-16 Thread Miles Thompson
Email List Subject: Re: [PHP] Inserting records in a particular way in MySQL Phillip, It doesn't matter, obviously you're not using the autoincrement ID for a foreign key. All this does is identify a record. If you did a SELECT and found a missing sequence number, what's to say t

RE: [PHP] Inserting records in a particular way in MySQL

2003-02-16 Thread Willie G
: Phillip S. Baker; PHP Email List Subject: Re: [PHP] Inserting records in a particular way in MySQL Phillip, It doesn't matter, obviously you're not using the autoincrement ID for a foreign key. All this does is identify a record. If you did a SELECT and found a missing sequence number, wha

RE: [PHP] Inserting records in a particular way in MySQL

2003-02-16 Thread Willie G
} if (is_numeric($lastkey)) { return $lastkey+1; } else { return 1; } $db->closedb(); } -Original Message- From: Phillip S. Baker [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 16, 2003 12:37 PM To: PHP Emai

Re: [PHP] Inserting records in a particular way in MySQL

2003-02-16 Thread Miles Thompson
Phillip, It doesn't matter, obviously you're not using the autoincrement ID for a foreign key. All this does is identify a record. If you did a SELECT and found a missing sequence number, what's to say that value would not be inserted by another user before your INSERT? If you have not set up

[PHP] Inserting records in a particular way in MySQL

2003-02-16 Thread Phillip S. Baker
Greetings all, I have some PHP code that is inserting records into a DB. Most of this is auto increment. However I know there is allot of breaks in the sequencing. I am wondering if there is some way to write the SQL code to search through the existing records in the DB and to find where the ne