row ID number

[Canman2005]

Dear all

I have a php insert query to insert some form data. Once the form has been submitted and the data added to the sql database, is there anyway to bring the auto increase ID number which is generated in the sql database?

Any help would be great.

Thanks

Ed

[AndyB]

[a href=\"http://ca.php.net/manual/en/function.mysql-insert-id.php\" target=\"_blank\"]http://ca.php.net/manual/en/function.mysql-insert-id.php[/a] will retrieve the last autoincrement ID

[Canman2005]

Hi

That worked great, thanks.

Can the value be passed to another page via a session? How would that be done? Tried few things without any luck.

Thanks in advance

Ed

[Canman2005]

Worked it out, if anyone is interested I passed

$_SESSION['nextid'] = mysql_insert_id();

with my php page action and then called the session name ($_SESSION['nextid']) on the next page.

Thanks anyone who helped

Ed