duplicate key when inserting in table

[eklee]

Hi,

I use PEAR DB for my db handling. The problem I am facing right now is, sometimes they might had possibility, have duplicate key(unique field) error, so it might cause either data not record into db at this time.

error message:
1062: Duplicate entry '1525758' for key 1
DB Error: already exists: INSERT....

So, is there any function i can use to lock the key id?

Thanks
Louis

[Anon]

Why don't you use auto_increment on your primary key?

[eklee]

Because I have I store my data in 2 different table, that's why I need to compare both table and get the latest key among.

The purpose I store my data in 2 different table because I dont' want another table data screw up my main table when inserting/deleting.