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]
[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]
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]