Thanks, just what I was looking for. George ----- Original Message ----- From: "matt stewart" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 3:26 PM Subject: 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:[EMAIL PROTECTED]] > Sent: 14 January 2002 14:56 > To: Ireneusz Piasecki; [EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > 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: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > -- > > > > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > --- > 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 > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] --- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]