what's the best way to get the auto_inc value of a table? is there a function bult into adodb or is it just a matter of querying the info_schema (which the db_user "may not" have read access to)
this works fine, but i'm concerned about DB permissions:
Code
$sql = "SELECT AUTO_INCREMENT
FROM information_schema.TABLES
WHERE TABLE_SCHEMA='".$GLOBALS['pnconfig']['dbname']."'
AND TABLE_NAME='".$ptable."'";
$result =& $dbconn->execute($sql);
list($next_post_id) = $result->fields;
FROM information_schema.TABLES
WHERE TABLE_SCHEMA='".$GLOBALS['pnconfig']['dbname']."'
AND TABLE_NAME='".$ptable."'";
$result =& $dbconn->execute($sql);
list($next_post_id) = $result->fields;
thanks for any insight/suggestions.
