Thank you, Ryan =) "Ryan Marrs" <rmarrs@strtrade.com> wrote in message 0CFC848DA61AE44FBC8C9718D354637C03287C09@dtw_localmail">news:0CFC848DA61AE44FBC8C9718D354637C03287C09@dtw_localmail... > Daniel, good luck in your endeavor, next time, just filter those with > attitudes out. Many people on this list are very helpful. A few are not. > > I had a complete "lose the attitude" speech written out, but I think I'll > just let you figure it out. > > Thanks for making this the great list it is Jason! > > <removes self> > > ___________________________________ > Ryan Marrs > Web Developer > Sandler & Travis Trade Advisory Services, Inc. > 248.474.7200 x 183 > 248.474.8500 (fax) > www.strtrade.com > > > -----Original Message----- > From: Jason Wong [mailto:php-db@gremlins.biz] > Sent: Tuesday, June 24, 2003 7:43 AM > To: php-db@lists.php.net > Subject: Re: Getting data on last INSERTed row > > > 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 > ------------------------------------------ > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
