[RESOLVED] sending record number to user once they enter their data

[Empire895]

Greetings,

I am trying to figure out how to send an e-mail to the register after they enter their info that will contain the ID assigned my the database after the data has been written.

I need the registerer to return with that ID to continue the registration process and I am unsure how to do this.

Currently the user will register their school info and then a school record is created in the database and the record is assigned the next record ID number.

The user will then be e-mailed this ID as their registration number for their school so they can return to the site, enter the ID and then proceed to enter delegate information for each attendee based on their school ID.

Hope this makes sense.

Thanks

[bradgrafelman]

That would depend on the database. The MySQL library, for example, has the [man]mysql_last_insert_id/man command.

[Empire895]

oops, sorry for not supplying more info...

yes MySQL, thanks for pointing me in the right direction.

🙂

PEACE!

[Empire895]

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

mysql_insert_id
(PHP 4, PHP 5, PECL mysql:1.0)

mysql_insert_id — Get the ID generated from the previous INSERT operation

Description
int mysql_insert_id ([ resource $link_identifier ] )
Retrieves the ID generated for an AUTO_INCREMENT column by the previous INSERT query.