Getting data on last INSERTed row

From: Date: Tue, 24 Jun 2003 11:37:22 +0000
Subject: Getting data on last INSERTed row
Groups: php.db 
Request: Send a blank email to php-db+get-28826@lists.php.net to get a copy of this message
Hi all! I'm wondering if there's an easy and non-system-demanding way to get data on an INSERTed row in PHP/MySQL? Specifically, I want the value of an auto-incremented primary key cell, "uid". I'm INSERTing a new person into a table, and need to return this value to a Javascript function that maintains an array of all persons in this table. I want to avoid a full SELECT query that would rebuild the array from scratch and put unnessecary load on the SQL server. I first thought of mysql_affected_rows, but as far as I can read, it only returns the value of rows affected, i.e. 1 on any INSERT statement executed? Any ideas? Thank you, Daniel -- There are 10 kinds of people: Those who know binary and those who don't.

« previous php.db (#28826) next »