Get next AUTO INC value for a tables auto inc column

  //Will get the next (not last) auto inc value from the table named MyTableName (you don't specify the column name)
  $sql = "SELECT AUTO_INCREMENT as NextAutoIncValue FROM INFORMATION_SCHEMA.TABLES WHERE table_name = 'MyTableName' and table_schema = database() ";