Re: finding out the result of an INSERT

http://php.net/manual/en/function.mysql-insert-id.php <---- from the link above ----> Warning: mysql_insert_id() converts the return type of the native MySQL C API function mysql_insert_id() to a type of long. If your AUTO_INCREMENT column has a column type of BIGINT, the value returned by mysql_insert_id() will be incorrect. Instead, use the internal MySQL SQL function LAST_INSERT_ID(). ----- Original Message ----- From: "Cable, Christian" <c.cable@lancaster.ac.uk> To: <php-db@lists.php.net> Sent: Tuesday, July 10, 2001 6:51 AM Subject: [PHP-DB] finding out the result of an INSERT > Hi, > > this might be a stupid question but it's got me stumped today > > My setup: php, mysql, apache etc > > I'm inserting a record into a table that's got a primary key which is auto > incrementing .. > > +---------------+---------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +---------------+---------------+------+-----+---------+----------------+ > | message_id | int(11) | | PRI | NULL | auto_increment | > | message_text | mediumtext | YES | | NULL | | > | topic_id | int(11) | YES | | NULL | | > | user_id | int(11) | YES | | NULL | | > | message_title | varchar(50) | YES | | NULL | | > | message_time | timestamp(14) | YES | | NULL | | > | parent_id | int(11) | YES | | NULL | | > | thread_id | int(11) | YES | | NULL | | > +---------------+---------------+------+-----+---------+----------------+ > > by doing > > $sql = "INSERT INTO messagetable(user_id, message_title, message_text,topic_id, > thread_id, parent_id) VALUES > > ('$userid','$subject','$comment','$topic_id','$thread_id','$parent_id')"; > mysql_query($sql); > > which works fine BUT is there any way of finding out the message_id of the > record I just inserted ? > > with thanks > > Christian > > > Christian Cable > ICT Assistant > Careers Service; Lancaster University > Tel: (01524) 594072 Fax: (01524) 592072 > http://www.lancs.ac.uk/staff/cable/ > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >