'.$database_collation.''; if ($conn = @ mysql_connect($host, $uid, $pwd)) { // get collation $getCol = mysql_query("SHOW COLLATION"); if (mysql_num_rows($getCol) > 0) { $output = ''; while ($row = mysql_fetch_row($getCol)) { $selected = ( $row[0]==$database_collation ? ' selected' : '' ); $output .= ''.$row[0].''; } $output .= ''; } } echo $output; ?>