如何获取上次插入的id
$datass = array (
'object_id' => $id,
'object_type'=>$ty,
'type' => $t,
'company_id'=>$c
);
return(db_query("INSERT INTO ?:discussion ?e", $datass));
现在我需要获取最后插入的 id ? 我怎么做。
查找上次插入的值的查询必须是
select * from tablename order by desc id limit 0,1
此处 id 必须是主键
试试这个:-
db_query('select * from tablename order by desc id limit 0,1');
您也可以
使用此方法。
db_get_field('SELECT MAX(field_name) FROM ?:table_name');