Take a look here and all will be revealed:
http://www.mysql.com/doc/G/e/Getting_unique_ID.html
basically, you need a field in the db with an auto_increment attribute.
Richard
CrossWalkCentral wrote:
> Question how do you use this function?
>
> mysql_insert_id();
>
> I have tried it and it gives me and error every time any one have any sample
> conde on this
>
> --
> Cross Walk Central
> www.crosswalkcentral.net
> Support Center
> Your Web Hosting Community!
>
> "Beau Lebens" <[EMAIL PROTECTED]> wrote in message
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
>> not so much in one step, but once you have inserted it you can call the
>> function
>>
>> mysql_insert_id();
>>
>> and it will return the auto_increment value of the last insert operation.
>>
>> see the manual for more.
>>
>> HTH
>> Beau
>>
>> // -----Original Message-----
>> // From: Scott Mebberson [mailto:[EMAIL PROTECTED]]
>> // Sent: Thursday, 9 August 2001 8:49 AM
>> // To: [EMAIL PROTECTED]
>> // Subject: [PHP-DB] Inseting info into MySQL and retrieving
>> // all in one SQL
>> // command
>> //
>> //
>> // Hi guys,
>> //
>> // I am adding some information to my MySQL database. It is
>> // user's information.
>> // So it has things like email address, password, username, all
>> // that sort of
>> // stuff.
>> //
>> // What I need to do is once I have added it found out the id -
>> // a primary key
>> // which auto increments itself. At the moment I am doing two
>> // different MySQL
>> // queries an INSERT and a SELECT to first of all add the
>> // information and then
>> // find out the primary key.
>> //
>> // Is there anyway I can do this in one step?
>> //
>> // Thanks in advance
>> //
>> // Scott Mebberson
>> // [EMAIL PROTECTED]
>> //
>> //
>> //
>> // --
>> // PHP Database Mailing List (http://www.php.net/)
>> // To unsubscribe, e-mail: [EMAIL PROTECTED]
>> // For additional commands, e-mail: [EMAIL PROTECTED]
>> // To contact the list administrators, e-mail:
>> // [EMAIL PROTECTED]
>> //
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
