How do you check unique existance?

[Jaxel]

Thanks Dismounted! That was exactly what I was looking for... I am now using the following code:

	$db->query_write("INSERT IGNORE INTO ".TABLE_PREFIX."rank_players (pName, pRegion, pTeam, pCount, pTotal, pAverage, pTopTotal, pTopAverage, pExt)
		VALUES ('".$name."', '".$region."', '".$team."', '0', '0', '0', '0', '0', '".$ext."')");

	$update = $db->affected_rows();

	if ($update)
	{
		$output = 'The entry for player (<b>'.$name.'</b>) has just been added to the database';
	}
	else
	{
		$output = '<font color="red">Unable to add (<b>'.$name.'</b>) - Player name already exists!</font>';
	}
	return $output;

Is there a function I can use to replace the following code in the same manner?

	$db->query_write("UPDATE ".TABLE_PREFIX."rank_players SET pName='".$name."' WHERE playerID='".$player['playerID']."'");
	$db->query_write("UPDATE ".TABLE_PREFIX."rank_players SET pRegion='".$region."' WHERE playerID='".$player['playerID']."'");
	$db->query_write("UPDATE ".TABLE_PREFIX."rank_players SET pTeam='".$team."' WHERE playerID='".$player['playerID']."'");
	$db->query_write("UPDATE ".TABLE_PREFIX."rank_players SET pExt='".$ext."' WHERE playerID='".$player['playerID']."'");