Mine

// Check if there's a clan with the same name already!
$sql = "SELECT name FROM ". CLANS_TABLE ." WHERE name = '".$name."' ";
if ( !($result = $db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Error retrieving data', '', __LINE__, __FILE__, $sql); }
while ( $row = $db->sql_fetchrow($result) )
{
	if(!empty($row['name']))
	{
		// Clan already exists!!
		$message = sprintf($lang['clans_couldnt_create'], '<b>'.$name.'</b>').'<br />'.$lang['clans_same_name'].'<br /><br />'.sprintf($lang['clans_click_here'], '<a href="'.$file.'?action=create">','</a>');
		message_die(GENERAL_MESSAGE, $message);
	}
}