Get last inserted record ID PHP-MySQL

This function gets last inserted records ID

function select_max_id($id="id",$my_table="cms_pages")
{
$db = new clsDBcms();//You may have different connection class 

  $SQL = "SELECT MAX($id) FROM ".$my_table;
  $db->query($SQL);
  if ($db->next_record())
  {
     $max_id = $db->f(0);
  }
$db->close();
return $max_id;
}
Start of page


Recommended

Link Partners

Web Design Forum

Start of page
© Copyright 1998-2013 Vision.To Design All rights reserved