ID after Insert

[Anon]

Hello,

I have a table called users. The user_id field is the PRIMARY KEY, and is to be auto_incremented. After inserting to the table using INSERT INTO, how can I get the user_id of the new record.

Also, I do not want to do a SELECT picking out the last record in the table because I want to do the same thing after using UPDATE on the table (which I'm sure will only return one record).

Thank you

[Anon]

mysql_insert_id will do just fine. Thank a lot!

[Anon]

I use PostgreSQL and I can use pg_GetLastOid which returns the the last object identifier.

But I can't find anything in the PostgreSQL manual where I can use this "the last object identifier" to get the primary key for the last inserted record.

Thanks in advance

Claus Sørensen

[Anon]

I have found a solution:

pg_Connect("dbname=my_database");
$res = pg_exec($conn,
"INSERT INTO table
(field1, field2)
VALUES
('$value1', '$value2');");

$lastoid = pg_GetLastOid($res);

pg_FreeResult($res);

$res = pg_Exec($conn,
"SELECT id
FROM table
WHERE oid = '$lastoid';");

$new_id = pg_result($res, 0, "id");

pg_FreeResult($res);
pg_Close($conn);

[Anon]

Patrick,

The INSERT worked great, and mysql_insert_id returned the ID. But when I'm updating, I updating using WHERE email = "[e-mail]". I'm sure there are never duplicates of the same email.

So I want to do: UPDATE .... WHERE email = "[e-mail]" and get the ID of that record.

I don't want to do another SELECT... WHERE email = "[e-mail]"... any solution???

Thanks a lot.

[Anon]

Because email fields have 40 characters long and an ID can be only 4 or 5. If you need these IDs to relate other data to users, then you can't afford a 40 bytes long field.
Bye