Advanced Search

Return to Snippet

Revision: 888
at August 19, 2006 06:19 by arcturus
Updated Code 
//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");

Revision: 887
at August 19, 2006 06:07 by arcturus
Initial Code 
//Bloqueamos la tabla
mysql_query("LOCK TABLES myTable WRITE");
//Hacemos el insert
mysql_query("INSERT INTO myTable ......");
//Obtenemos el id del proyecto
define('MY_ID',mysql_query("SELECT LAST_INSERT_ID()"));
//Desbloqueamos
mysql_query("UNLOCK TABLES");
Initial URL 









Initial Description





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









Initial Title





Select index from last inserted item.









Initial Tags





mysql, php









Initial Language





PHP