RE: [PHP-DB] Inseting info into MySQL and retrieving all in one S QL command
| From: | Beau Lebens | Date: | Thu, 09 Aug 2001 00:51:50 +0000 |
| Subject: | RE: [PHP-DB] Inseting info into MySQL and retrieving all in one S QL command | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11145@lists.php.net to get a copy of this message | ||
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:scott@redbluedesign.com]
// Sent: Thursday, 9 August 2001 8:49 AM
// To: php-db@lists.php.net
// 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
// scott@redbluedesign.com
//
//
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
// For additional commands, e-mail: php-db-help@lists.php.net
// To contact the list administrators, e-mail:
// php-list-admin@lists.php.net
//