I use an auto increment field to uniquely identify my records in a MySQL table.
When I insert a new record, a new unique id is created but how can I find out what the number is so I can refer to it immediately?
Any help gratefully received.
[SOLVED] Finding record number of newly inserted record
Moderator: General Moderators
[SOLVED] Finding record number of newly inserted record
Last edited by davidtee1 on Sun Jun 12, 2005 8:42 am, edited 1 time in total.
-
malcolmboston
- DevNet Resident
- Posts: 1826
- Joined: Tue Nov 18, 2003 1:09 pm
- Location: Middlesbrough, UK
Code: Select all
// insert statement + call here
$lastID = mysql_insert_id();