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]
