PULL ID FROM DATABASE?

[Anon]

I have entered an item into the database nd now I want to pull the newly assigned ID from the database (relating to the item entered). What PHP function (if any) will allow me to check this? Or, what would be the best way to check this? Thanks!

[neuromancer]

Ask your database user manual, or supply more information (like the database server your using)

[Anon]

If you're using mySQL the use the function mysql_insert_id()
It will return the most recent auto increment entered into the DB.

Use like so:

echo(mysql_insert_id());

If your autoincrement is a BIGINT then use the mySQL function LAST_INSERT_ID(); instead

Use like so:

$query = "SELECT LAST_INSERT_ID()";

yada yada.....