[solved] Help with using mysql_insert_id

[John Alexander Hopper]

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]

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 all

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

[John Alexander Hopper]

Hi

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

John