shortcode not working

right just writing my first proper plugin. Finished activation and deactivation part.

Added a new shortcode but for some reason the shortcode is not getting parsed and I am getting no error. As far as I can tell the function to replace the shortcode doesn't even get called.

here is my code.

Can anyone see any problems with it?

add_shortcode('cs_currency_converter', 'cs_currency_converter_func');

function cs_currency_converter_func($atts) {
    
    $sql = 'SELECT * FROM `cs_currency` ORDER BY `name`';
    $query = mysql_query($sql);
    
    $options = '';
    
    while ($result = mysql_fetch_assoc($query)) {
        $options .='<option value="'.$result['id'].'">'.$result['code'].' - '.$result['name'].'</option>';
    }
        
    $html = '<form action="#" method="post">';
    
    $html .= '<select name="cs_currency_from">';
    $html .= $options;
    $html .= '</select>';
    
    $html .= '<select name="cs_currency_from">';
    $html .= $options;
    $html .= '</select>';
    
    $html .= '</form>';
    
    return $html;
}

PHP:

 

ok never mind. I fixed the issue myself. seems like 'cs_currency_converter' was too long.

thanks anyway