// 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'], ''.$name.'').'
'.$lang['clans_same_name'].'

'.sprintf($lang['clans_click_here'], '',''); message_die(GENERAL_MESSAGE, $message); } }