Re: [PHP-DB] Inseting info into MySQL and retrieving all in one SQL command
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]
Re: [PHP-DB] Inseting info into MySQL and retrieving all in one SQL command
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]
RE: [PHP-DB] Inseting info into MySQL and retrieving all in one SQL command
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]