Re: Getting data on last INSERTed row

Well, to tell you the truth, I thought I did. I may be a newbie and perhaps a little daft, so please excuse me if I ask stupid questions. Apart from that, thank you for your help. "Jason Wong" <php-db@gremlins.biz> wrote in message news:200306241943.28841.php-db@gremlins.biz... > On Tuesday 24 June 2003 19:37, Daniel wrote: > > > 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? > > Yeah, did it ever cross your mind to read the manual? > > mysql_insert_id() > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.biz > Open Source Software Systems Integrators > * Web Design & Hosting * Internet & Intranet Applications Development * > ------------------------------------------ > Search the list archives before you post > http://marc.theaimsgroup.com/?l=php-db > ------------------------------------------