Quote Originally Posted by mc12345678 View Post
Sorry, there was a typo in the original query (@products_options_type_id should have been @products_options_types_id) :

Code:
SELECT @products_options_types_id := pot.products_options_types_id+1
            FROM `products_options_types` pot    
            order by pot.products_options_types_id desc limit 1;

INSERT INTO `products_options_types` (products_options_types_id, products_options_types_name) VALUES (@products_options_types_id, 'Link');

INSERT INTO `configuration` (configuration_title, configuration_key, configuration_value,
        configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES ('Link product option type', 'PRODUCTS_OPTIONS_TYPE_LINK', @products_options_types_id, 'Numeric value of the link product option type', 6, 0, now(), NULL, NULL);
I don't know why an error occurred with the removal as I just ran it (twice) to see if I would get an error...
THAT WORKED!....so does it work with drop-down boxes?