[solved] Help with using mysql_insert_id

John Alexander Hopper · March 8th, 2008, 03:03 PM

Hi all

I'm building a web application for a client, and I'm a little stuck on using the "mysql_insert_id" function.

Basically, once a member registers, their profile information is inserted into the central database, which is not a problem - done this hundreds of times before.

The problem is that the client wants the members to be emailed their account login information, as soon as registration is complete.

I'm using Dreamweaver 8, so how would I go about getting the unique id of the last inserted ID so that I can create a recordset, based on this?

Hope I've made myself clear enough, please feel free to email me for further clarification!

Many thanks

John Alexander Hopper

CloudedVision · March 8th, 2008, 04:42 PM

I've had the exact same problem. You can either set the id to auto_increment, (The easiest way) or you can use a query like this:

Code:

SELECT `id` FROM `my_table` ORDER BY `id` ASC LIMIT 0,1

John Alexander Hopper · March 8th, 2008, 06:16 PM

Hi

Thankyou very much for that - it's sorted my problem!

John