MySQL db_next_id

Hey, not sure if anyone is interested in this... but I didn't want to ask my host to give me lock tables permission, so I instead wrote an atomic db_next_id replacement that does without it....

Enjoy!

function db_next_id($name) {
	$name = db_prefix_tables($name);
	$result = db_query("update {sequences} set id = last_insert_id(id+1) where name = '%s'", $name);

	if(!db_affected_rows($result)) {
		db_query("insert into {sequences} (id, name) values (0, '%s')", $name);	
		db_query("update {sequences} set id = last_insert_id(id+1) where name = '%s'", $name);
	}
	return mysql_insert_id();
}

Nick.