Unique ID question

[yoki]

Hi,

I would like to know what would be the best method to generate a unique ID in a MySQL database for each form submitted?

I thought of maybe counting how many records are in the database right before inserting my data to the database but what if a record in submitted at the same time and then having the same unique ID.

What is the best way of doing this?

[rincewind456]

Set the field type to auto_increment

[thorpe]

use an AUTO INCREMENTING field. eg

CREATE TABLE tbl (
id INT PRIMARY KEY AUTO INCREMENT
);

[yoki]

Yes, I thought about doing that...Now I need this ID field in 2 or maybe 3 tables as a primary key. How can I store it this value in more than one table?

[Weedpacket]

Use a database that uses proper sequences (i.e., something other than MySQL) :evilgrin: