mysql : Any command to use instead of mysql_insert_id(); in PHP?

Question

I want to get primarykey ID of just insert item. In PHP has mysql_insert_id(). I write in C#

What database access technology are you using? – Mark Byers Dec 18 '10 at 20:18 — Mark Byers, Dec 18 '10 at 20:18

score 1 · Answer 1 · answered Dec 18 '10 at 20:15

1

You have to query the database directly.

SELECT last_insert_id() FROM mytable;

So say with ODBC

object lastID = new OdbcCommand("SELECT last_insert_id() FROM mytable", _connection).ExecuteScalar();

answered Dec 18 '10 at 20:15

Novikov

score 1 · Accepted Answer · answered Dec 18 '10 at 20:17

1

If cmd is your command object try:

  cmd.LastInsertId;

answered Dec 18 '10 at 20:17

Adrian Serafin

2 Answers2