Hi.
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 ]
--
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]
