[SOLVED] Primary key of an insert table

[studgate]

hi Guys,

  I am trying to update a table that I just insert inot the database.

i insert the value and I want to get the primary key of that entry

and update another field with that same value.

 

Example: TABLE (ID, NAME, OTHERFIELD)

            INSERT into table (name) VALUES ('$NAME');

            UPDATE table SET (OTHERFIELD) VALUES (ID)

 

I hope I explain it properly.

let me know if you have a question

[947740]

Just redefine the table layout.  Make the "OTHERFIELD" SERIAL, like the ID.  They should then be the same value.  There is no point in having to manually update it when you can have MySQL do it for you.

[Barand]

After the first insert, call mysql_insert_id() to get the last auto_inc key that was allocated to it.

 

But why do you need two fields in the same record that will always have the same values?

 

 

[studgate]

I am creating a simple forum

I want to be able to get the initial message id so

when someone is replying to it, I can update the database.

I can get the reply message working but the post is what I

am having problem with.

[studgate]

mysql_insert_id is a little risky because what if two users

are posting messages at the same time??

[Barand]

It returns the last id for your connection, each user has a different connection,

[studgate]

ok, I got it thanks, I got it working.