Returning a value that was just entered.

[bduncan]

I have a web form that is inserting data into a mySQL table. The last field in this table is an auto-numbered id field. I would like to automatically return this id number so that the users can then view their data on another page. Is there a way to do this so that someone with my little experience can do this?

The code that I have for my query is:

$result = mysql_query($query);
if ($result)
{echo mysql_affected_rows(). " record inserted into database. Record number".[idnumber];}

else
{echo "it didn't work.";}

Everything works except for the ".[idnumber]" on the end. What I am trying to do is pull out that auto-numbered field for the just entered record.

Thanks.

[Anon]

PHP has a command in it's mysql functions that will return the last autoincrement ID number created. Unfortunately I can't seem to get there site to come up or I'd give you a link to it.

[Anon]

The function you are speaking of is mysql_insert_id().

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

[pratheshshah]

u have to use mysql_insert_id()

the above function return the last incerted id using auto increment column

u try this out

bye

[bduncan]

Thank you very much for your help. I was able to get it working and now they can view the datathey just entered in the format they are used to.

I appreciate the help.