Can you submit data and get a record # back in one click?

[system]

Hi All,

I want to add a new employee into an “Employees” table through a form.

Is it possible (in the same click) to submit this data, and then have the page return the auto-assigned record # for that new employee? (The MySQL-generated #)?
If so, how do I do this?

Thanks!

Chris

[richei]

yea its possible, look up how to use mysql_last_id().