[solved]Getting a Primary Key after inserting into a table?

[eluser]Mirge[/eluser]
If you had a table like:

Code:

CREATE TABLE test (
id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
patient_name VARCHAR(50) NOT NULL,
patient_weight INT UNSIGNED NOT NULL,
...rest of your fields here...
);

id would be your primary key.

Code:

$result = $this->db->insert("....");
$id = $this->db->insert_id();

echo "The primary key (id) for the record I just inserted is $id";

See: http://ellislab.com/codeigniter/user-gui...lpers.html