[Resolved] mysql_insert_id()

redzzzon

I created a db so to update a post

when a browser submits a post I have four tables take in values.

The tables are

Autor
PK Author

has a

note
PK noteID
FK Author

is a

Post
PK PostID
FK BullitenID
FK noteID
description

Which belongs to

board
PK bullitenID

My problem is updating POST TABLE with the FK values created when inserted at the patent tables.

I came across mysql_insert_id();

however I am not sure.

I have created plenty of insert for dbs without referential joins.

Thanks

Drakla

Could you elaborate a bit more? mysql_insert_id() returns the auto increment of the last insert you did. If it was a multiple insert statement it returns the id of the first insert of the group.

PS you've spelt mathEmatical wrong in your sig - unless it's something cool I'm missing out on on the back of this apple cart.

redzzzon

when a user posts a new note I need four tables to insert a new row for each table. Some of those rows will depend on the value of the last insert which was a parent table and needs the PK value for the purpose doing select joins.

Thomas

devinemke

you've pretty much answered you own question. use [man]mysql_insert_id[/man] to get the relavant PK that needs to be inserted as FK's in the related tables. obviously, the order in which you do the queries is important as you will need the PK for a given table before you can do the INSERT on another as an FK.