Mysql new entry - give me 'id' in php

Hi,

I'm making php script that posts new entry in mysql, the form of it is in flash which sends the data over to php in $_POST. Is it possible to make php script return under what 'id' that new entry has been saved?

The flash is a christmas card where first you put some text, click send and then it should display a direct link (with that 'id') to saved x-mas card, example: 'site.com/card.php?id=312'.

Never mind, I just out that mysql_insert_id(); is the think I was looking for.

Sorry I didn't see this topic sooner. mysql_insert_id() is exactly what you're looking for, as you've already discovered

Funny thing, the other day I was busy testing stuff and adding records. deleting records, updating records in my MySql DB and mysql_insert_id() returned an incorrect value for me, I was busy on my site and editing the DB through MySql Query Browser and I screwed something up so I had to reset the values for the auto_increment fields in both tables I was working on ... just look out for something like that ...

mysql_insert_id() returns the auto_increment id of the LAST insert query on that connection. If you have a busy site and you're maintaining connections, it is possible that you have two get the same id....


Page 1 -> Insert Query
Page 2 -> Insert Query
Page 1 -> Insert_id?
Page 2 -> Insert_id?

No good.