Something like this perhaps.... untested
function insert($query) {
// Connect info
mysql_connect("host","user","pass");
// Select DB
mysql_select_db("DBname");
// Perform insert
$indb=mysql_query($query);
// Gets record ID
$dbq=mysql_query("select last_insert_id()");
$data=mysql_fetch_row($dbq);
// Return ID
return $data[0];
}
---------------------------------------------------------
Chris Kay
Techex Communications
Website: www.techex.com.au Email: [EMAIL PROTECTED]
Telephone: 1300 88 111 2 - Fax: 1300 882 221
---------------------------------------------------------
-----Original Message-----
From: Daniel Page [mailto:[EMAIL PROTECTED]]
Sent: Friday, 14 February 2003 8:18 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Add a record and recover it's ID in one operation
Thanks!
I stand corrected. I'll check the PHP online manual more often, and for now,
I'm off to optimise my database and rewrite a few queries :)
Cheers,
Daniel
"Leif K-Brooks" <[EMAIL PROTECTED]> a �crit dans le message de
news: [EMAIL PROTECTED]
> www.php.net/mysql-insert-id
>
> Daniel Page wrote:
>
> >Hi,
> >
> >Imagine a table with an auto-increment id number field and a text field
for
> >the username.
> >User B (with user name 'johnny') could write to the database a
millisecond
> >after user A, with the same username. When user A looks for the last
record
> >written by Johnny, A will find the record entered by B.
> >
> >Is there a way to directly recover the auto-incremented number as like a
> >return value (or somthing like that) of the write query as to be able to
> >identify immediately what record you just wrote?
> >
> >This is just for argument's sake - I just would like to know if it is
> >possible. My current solution is inserting the login time of the current
> >user and/or IP, and adding that to make a temporary ID key where you
select
> >the latest entry written where username = your username and login time
> >string = hhmmss info so you can immdately find your latest entered data,
> >though recovering immediately the ID would have been a more elegant
solution
> >for this.
> >
> >Cheers,
> >Daniel
> >
> >
> >
> >
> >
>
> --
> The above message is encrypted with double rot13 encoding. Any
unauthorized attempt to decrypt it will be prosecuted to the full extent of
the law.
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
