db_last_insert_id

Returns the last insert id.

Parameters

$table: The name of the table you inserted into.

$field: The name of the autoincrement field.

Related topics

Schema API

A Drupal schema definition is an array structure representing one or more tables and their related keys and indexes. A schema is defined by hook_schema(), which usually lives in a modulename.install file.

91 functions call db_last_insert_id()

File

drupal/includes/database.mysql-common.inc, line 539

Functions shared between mysql and mysqli database engines.

Code

<?php
function db_last_insert_id($table, $field) {
  return db_result(db_query('SELECT LAST_INSERT_ID()'));
}
?>