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(); 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