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
Phillip, You will have to change your code, so the primary key is not an auto incremented value. If you don't, the auto increment will over-ride the 'get next' function. Here is what I use in my code. You just need to change it for your table. //- GetNextKey -// function getnextkey(){

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