[Resolved] How to use mysql_insert_id() ?

[Joseph_Sliker]

Hi;

I'm getting really fancy now. I'm trying to build some tables that are better "normalised" than I usually try for (less redundant data being stored).

To do so, I need to have an INSERT query return the auto_increment value of the primary key. (So I can relate multiple records to be stored in another table to the item in this first table).

The MySQL docs describe a function ( mysql_insert_id() ) that apparently does such a thing, but, sadly, the description was not sufficiently concrete for me to understand and there were no examples.

I'll keep digging, but if someone could give me a quick example of code that would return the value, I'd appreciate it.

Thanks!

[bastien]

$result = mysql_query($sql);

$my_id = mysql_insert_id();

they must occur right after each other...no addtional code in between the statements

[Joseph_Sliker]

Thank you for the reply.

I had just found much more complete information about the function on

www.php.net

http://www.php.net/manual/en/function.mysql-insert-id.php

I think I should be able to do this now.

Thanks again.