how to get last inserted id from database (in prestashop)

[tahir.nazir]

hi
can anybody tell me how can i get last inserted id from database (in prestashop)?

[rocky]

The last id of what? You could click on the down arrow under the ID header of a table in the Back Office and the last ID would be displayed first, or you could write a MySQL query on one of the Prestashop database tables to select the max ID.

[peorthyr]

in php, there is a function that does that:

http://php.net/manual/en/function.mysql-insert-id.php

hope it helps.

[vekia]

peorthyr has got right

 

you can use mysql_insert_id()

 

for example:

 

<?PHP
$lastid=mysql_insert_id();
echo $lastid;
?>

[peorthyr]

sorry wrong post

Edited February 20, 2013 by peorthyr (see edit history)