RE: [PHP-DB] grabbing id from new record

straight after you do the insert command, use the call: $ID = mysql_insert_id(); The $ID is now the primary key for the record you just inserted. -----Original Message----- From: George Pitcher [mailto:fmdev@yahoo.co.uk] Sent: 14 January 2002 14:56 To: Ireneusz Piasecki; php-db@lists.php.net Subject: Re: [PHP-DB] grabbing id from new record I am sorry, I was not clear in my original request. The id is auto-incremented. I want to grab the id so that I can use it as part of a redirect $q2="select Course_ID from course where HEI_ID = '$inst' order by Course_ID desc limit 0,1"; $result2=mysql_query($q2) or die("q2 failed"); while ($row = mysql_fetch_array ($result2)) { $recid=$row['Course_ID']; } $redirect=('Location: http://localhost/Mysite/itemlist.php?recid=' . $recid); header($redirect); As I said, it works but maybe there's a better way. George > What about Auto_increemnt field ?? > Your's id can be auto_increment field. for example: > create table dupencja (id int(7) auto_increment not null, primary key(id)); > > so when you insert records: > insert into dupencja values('') - > id will be 1 > insert into dupencja values('') - > id will be 2 > > this is auto_increment, so your trick isn't need. > > More in manula of mysql. > regards. > I piasecki - www.b-c.pl > > > > > ----- Original Message ----- > From: "George Pitcher" <fmdev@yahoo.co.uk> > To: <php-db@lists.php.net> > Sent: Monday, January 14, 2002 3:23 PM > Subject: [PHP-DB] grabbing id from new record > > > > Hi, > > > > Is there a way to grab the ID (from ID field) while INSERTing a new > record? > > > > I am currently doing a separate INSERT then a SELECT query to find the > most > > recently added record by that user: > > > > select ID from table where user = '$user' order by ID DESC limit 0,1 > > > > This does the trick but it may not be the most efficient way. > > > > George > > > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01 > > > > > > _________________________________________________________ > > Do You Yahoo!? > > Get your free @yahoo.com address at http://mail.yahoo.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 > > > > > > -- > > Znudzilo Ci sie logo w komorce? > Wgraj nowe [ http://komorki.onet.pl/dodatki.html ] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.307 / Virus Database: 168 - Release Date: 11/12/01 _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.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 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.313 / Virus Database: 174 - Release Date: 02/01/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.313 / Virus Database: 174 - Release Date: 02/01/02