select category_id, category_type, short_name, description from rl_resource_category where category_id = :category_id select short_name, category_id as my_cat_id from rl_resource_category_type UPDATE rl_resource_category SET category_type = :category_type, short_name = :short_name, description = :description WHERE category_id = :category_id insert into rl_resource_category (category_id, category_type, short_name, description) values (:category_id, :category_type, :short_name, :description)