$sql = "SHOW TABLE STATUS LIKE 'table_name'";
$res = $mdb2->query($sql);
if (PEAR::isError($res)) {
die($res->getMessage());
}
$result = $res->fetchRow();
$next_id = $result['auto_increment'];
$sql = "SHOW TABLE STATUS LIKE 'table_name'";
$res = $mdb2->query($sql);
if (PEAR::isError($res)) {
die($res->getMessage());
}
$result = $res->fetchRow();
$next_id = $result['auto_increment'];