--- BD <[EMAIL PROTECTED]> wrote:
> Son,
>
> At 09:48 PM 4/7/2002, you wrote:
> >mysql> desc threads;
>
>+-------------+--------------+------+-----+---------+----------------+
> >| Field | Type | Null | Key | Default | Extra
> |
>
>+-------------+--------------+------+-----+---------+----------------+
> >| thread_ID | int(11) | | PRI | NULL | auto_increment
> |
> >| subject | varchar(255) | YES | | NULL |
> |
> >| author | varchar(30) | YES | | NULL |
> |
> >| last_by | varchar(30) | YES | | NULL |
> |
> >| views | int(11) | | | 0 |
> |
> >| date_posted | datetime | YES | | NULL |
> |
>
>+-------------+--------------+------+-----+---------+----------------+
> >6 rows in set (0.00 sec)
> >
> > $SQL_insert_thread = "INSERT into threads ";
> > $SQL_insert_thread .= "(subject, author, last_by, views, ";
> > $SQL_insert_thread .= "date_posted) " values ";
> > $SQL_insert_thread .= "(\'some_subject\', \'test_username\',
> > $SQL_insert_thread .= "\'test_username\', 1, now())";
> >
> > In the table threads above, I do have a field: "thread_ID" with
> >auto_increment value. My question is can I obtain the value
> thread_ID
> >while I do the insert statement just by 1 mySQL statement? If yes,
> >please can somebody give me a sample code?
>
> execute the MySQL query: select last_insert_id();
1st: select last_insert_id() doesn't work
2nd: It's not the answer I am looking for ... Because of the race
condition if two users access the that script at the same time... I
will have when I leave the INSERT statement !!!
Here is what I mean: think about this situation:
USER 1 ===> INSERT
STOP <== due to process scheduling
USER 2 ===> INSERT
SELECT last_insert_id();
USER 1 ===> SELECT last_insert_id();
It's the race condition, I am talking about.
> and retrieve the returned value
>
> or
>
> $last_thread_id = mysql_insert_id();
> This function will not work properly if the auto-incrementing column
> is
> BigInt, because PHP does not have a BigInt equivalent. Int or smaller
> works
> fine.
>
> Brent
>
>
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
