Need to get that ID as inserting info into table

[Anon]

First, i am using mysql database
I am looking to get that primary key
( at this point its 'id' in my tables )
as i insert the information into my tables. I am thinking of adding another column to my table which will contain a unique number
it will be inserted into my table with all the other info and then search my table for a row with that number. there u go
but i think there is a better idea that will tell u the id of just inserted row, not "last created" because its a multi user script.

THanx a lot, seriously !!!!

peace

[Anon]

If your "ID" is a primary key, that means it is already unique.
If you make that an "auto increment" field the database will insert a new unique value for every record you insert into your database.
Then you can use the php function mysql_insert_id to get the ID of the last inserted record.

Note: this is the last inserted record for the connection that you are using.
If you are using several connections for multiple users, you will still get the ID of the last inserted record for_each_user, and not just the last record that was inserted into the database.