public static function getNextId($field) { if (!empty($field)) { $field = DBUtils::mysql_escape($field); $SQL = "SELECT * FROM " . TBL_KEYGENERATOR . " WHERE PK_COLUMN = '" . $field . "'"; $query = mysql_query($SQL) or die(mysql_error()); $result = mysql_fetch_array($query); if (empty($result)) { return DBUtils::setNextId($field); } else { $val = $result['VALUE_COLUMN'] + 1; $SQL = "UPDATE " . TBL_KEYGENERATOR . " SET VALUE_COLUMN={$val} WHERE PK_COLUMN = '" . $field . "'"; mysql_query($SQL) or die(mysql_error()); return $val; } } else { return -1; } }