auto generated IDs

[ameliabob]

Is there a way without doing an additional search to find the number of an inserted row immediately after it has been added?

 

I need to reference a row with rows immediately after it when inserting data into the data base.

 

e.g

 

insert Header Row

insert detail row with a link back to Header Row

insert detail row with a link back to Header Row

insert detail row with a link back to Header Row

 

So the table would be

ID Link Contents

1 0 Header

2 1 Detail1

3 1 Detail2

4 1 Detail2

 

[justsomeguy]

Yes, each database has a way to get the identity value that was just created. Look up the documentation for the database you're using to see how it does it.

[ameliabob]

I looked in the mysql area and couldn't find any desription on how to use it???

[davej]

This sounds quite squirrely to me. I think it breaks some rules of table normalization, because you are throwing dependencies into the table.

 

http://en.wikipedia.org/wiki/Database_normalization

 

You would need to look at transactions and probably stored procedures.

 

(edited Dec08 9:05am)

[JamesB]

http://php.net/manual/en/mysqli.insert-id.php