一个sql获取表的min和max值
SELECT MIN(log_ID), MAX(log_ID) FROM zbp_post
function usebreakid_GetMinMaxID($table, $fieldID)
{
global $zbp;
$sql = $zbp->db->sql->Select($zbp->table[$table], array("MIN($fieldID)", "MAX($fieldID)"));
die($sql);
$res = $zbp->db->Query($sql);
if ($res) {
$d = array_values($res[0]);
return array($d[0], $d[1]);
} else {
return array(0, 0);
}
}