如何获取最后一个插入ID

Question

How to get the last insert id

INSERT INTO `cscart_static_data` ( `param_id` , `param` , `param_2` , `param_3` , 
`param_4` , `param_5` , `section` , `status` , `position` , `parent_id` , `id_path` , 
`localization` , `company_id` ) 
   VALUES ('','index.php?dispatch=postview.view', '', '', '', '1', 'A', 'A', '0', 
           '0', '152', '', '1' ); 

INSERT INTO `cscart_static_data_descriptions` ( `param_id` , `lang_code` , `descr` )
 VALUES ( SELECT LAST_INSERT_ID(), 'en', 'Blog' ); 

Here , the second query doesn't work for me, because 'SELECT LAST_INSERT_ID()' is empty .How to solve

Answer 1

$sql = INSERT INTO `cscart_static_data` ( `param_id` , `param` , `param_2` , `param_3` , `param_4` , `param_5` , `section` , `status` , `position` , `parent_id` , `id_path` , `localization` , `company_id` ) VALUES ('','index.php?dispatch=postview.view', '', '', '', '1', 'A', 'A', '0', '0', '152', '', '1' ); 
 mysql_query($sql);
 $last_insert_id = mysql_insert_id();

Now use this "$last_insert_id" in your select query