Posted By

arcturus on 08/19/06

Tagged

mysql
php

Versions (?)

Last Edited at 08/19/06 06:07am

Statistics

Viewed 1213 times

Favorited by 0 user(s)

Related snippets

Select index from last inserted item.

/ Published in: PHP

Select the last autoincrement index from the last inserted item in a table.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

//Bloqueamos la tabla
mysql_query("LOCK TABLES myTable WRITE");
//Hacemos el insert
mysql_query("INSERT INTO myTable ......");
//Obtenemos el id del proyecto
$result_id=mysql_query("SELECT LAST_INSERT_ID()");
define('MY_ID',mysql_fetch_row($result_id));
//Desbloqueamos
mysql_query("UNLOCK TABLES");